How To Increase Max User Connection

[leakd]

Zend_Db_Adapter_Mysqli_Exception: User ****** already has more than 'max_user_connections' active connections - library/Zend/Db/Adapter/Mysqli.php:333

 

[wolstech]

You can't increase the limit, but rather need to fix or replace the software.

 

Something you're running isn't closing its connections. You'll need to either debug your code so it closes connections properly, or if you installed that program off the web, ask the author why it's opening so many connections and not closing them. You may need to find different software.

 

We limit MySQL to 4 concurrent connections to avoid overloading the MySQL server. 99% of programs out there will work fine with this limit. The 1% that don't are either poorly written, broken, or would need enough resources that you'd get suspended for high load.