PDA

View Full Version : "max user connections"


profihr
02-22-2011, 07:04 AM
Why appears this "max_user_connections"?
profihr
02-24-2011, 07:44 AM
General Error
SQL ERROR [ mysql4 ]

User [username] already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
profihr
05-17-2011, 02:56 PM
my users reported .... this bug appear every day, what it is??

SQL ERROR [ mysql4 ]

User varazdin_akarlov already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
felgall
05-17-2011, 07:27 PM
You are trying to create too many connections to the database at the same time.
Ajay1
05-18-2011, 03:46 AM
I am running a survey that requires a fairly large number of participants to be on the survey at once. Survey is running very slow to load each question.
redsox9
05-18-2011, 06:31 AM
Are you using a particular software package to run the survey or is it home-grown? We need more details to pinpoint the issue.
felgall
05-18-2011, 12:27 PM
that requires a fairly large number of participants to be on the survey at once.

That does not necessarily mean that they all need to have the database open at the same time. If your script opens and closes the database just while actually updating it should be able to handle several thousand users sharing the one connection.
almannai
10-27-2011, 08:10 AM
We are geting those all the time from bluehost hosting
Guys you should increase the 'max_user_connections' you are old hosting provider be more generous
alemcherry
10-28-2011, 02:31 AM
Possible solutions:
1. Your script is poorly coded, it takes too much time to run queries and thus pages. Optimizing script/ database should work.
2. You have too much traffic for a shared hosting environment.
3. Your servers are slow, they take time to execute mysql queries and thus you end up having too many connections made at the same time.

The solution is to do mysql / PHP optimization (persistent connections, indexing tables, optimizing queries etc). If nothing works, you need to upgrade to a dedicated server which BH anyway do not provide.
redsox9
10-28-2011, 04:58 AM
We are geting those all the time from bluehost hosting
Guys you should increase the 'max_user_connections' you are old hosting provider be more generous

You realize that this is a user-to-user forum, right?