"SQL Error: 1040 - Too many connections" issue pls help?

[shaun_shaun]

few days ago I got this error

"MyBB has experienced an internal SQL error and cannot continue. SQL Error: 1040 - Too many connections Query: [READ] Unable to connect to MySQL server"


Later I contacted my host and they increased the no of

max_active_connection to 25​

but what is the meaning of that setting ?? is that means only 25 users can log in to my site simultaneously???

I asked the same question from the host but they said "there is limit on a server to connect with mysql database to 25 from a same ip at a time"

so that 25 connections means 25 connections from a same ip at a time??


I want to know if they are lying or not ???

 

[bxflow]

your site might be too big for shared

it means only 25 query executions I believe.

 

[janu123]

Yeah upgrade to vps now

 

[feronso]

25 is default max_user_connection is MySQL.

host will increase your connection if you paying them more. ask them that they have any package about this.

If you do not wish to paying them more, just simply install modifications which restricts users to posts in time but that do not use more MySQL resources. it means some users try to open your sites in different tabs and submitting a multiple posts at a time.

In MyBB i don't know how many queries are performing when you refresh a page. and some modification and queries require 1 connection per query. So if 1 person try to post in your forum with 3 or 4 tabs already opened so your MySQL must be generated this error and the person faced "MySQL Driver Error: or "Too many connection error" on their screen.

This is not a worried error. but i believe its kicked your users from your forum. specially that users who love to post in your forum. So always asking with host about max_user_connection limit before purchasing services. Most of give 20 connection like Hostgotar.

 

[shaun_shaun]

thax for the replies guys !!!