November 5, 2024

Recently, my phpbb forum has been getting these type of errors frequently:

mysql_connect() [function.mysql-connect]: User has already more than ‘max_user_connections’ active connections

Warning: mysql_connect() [function.mysql-connect]: Too many connections

I logged into mysql and used “show processlist”, and it showed 15 processes. That doesn’t sound too high to me.

I submitted a ticket to my web hosting company and they replied back that they would fix it. And it seems like the only thing they did was bounce MySQL.

I used the MYSQL “status” command and the uptime showed they just bounced it.

Then looked at the settings with “show settings” command. “max_connections” is set to 500. That looks pretty high to me. And “max_user_connections” is set to 15. I think this is the culprit. It matches the processlist of 15 users.

Just to see what would happen, I tried “set max_user_connections=50”. It said I didn’t have permission to do that.

After asking the webhost if they could increase “max_user_connections”, they said it cannot be changed. And it was not the limit I was hitting. The server was hitting the 500 connection limit. And it was other sites on the same server that is causing the issues.

Well, that’s good that it wasn’t me causing the problems. But, it’s not good that someone else has been causing me problems. Well, I guess there’s nothing I can really do about it unless I decide to go with dedicated hosting.

PHPBB:
Are connections persistant by default?
Mysql error
max_user_connections issue

MySQL:
System variables
Too many connections

Others:
Wallpaperama
vbulletin
MySQL error: User has already more than ‘max_user_connections’ active connec