Submit a Ticket
Support Center » Knowledgebase » Databases » max_user_connections (Shared Accounts)

max_user_connections (Shared Accounts)

In order to prevent resource starvation, and performance degradation issues of the server where your shared account is hosted, we have deployed a default limit of the MySQL: max_user_connections variable for all of our shared hosting package. If you hit this limit, your website will most likely throw an error message that looks like this:

"Warning: mysql_connect(): User xxxxxxxx already has more than 'max_user_connections' active connections in /home/xxxxx/public_html/xxxxxxxx.php on line X"

In general if you are hitting the default max_user_connections limit that we have set, we recommend that you look into optimizing your applications code further to reduce slow queries which are one of the main reasons you maybe reaching this limit, or investigate any potential issues with high traffic, or abuse related issues such as attacks towards websites or applications hosted within your account.

The same error you may get if you are using WordPress or any other popular application like Joomla, Drupal, etc. In these cases a bad plugin, module, extension can be causing this issue, or generally a need for further tuning of the application maybe required. We recommend that you review the following Performance Optimization Tips, in order to speed up your website in general, which will most likely resolve the error you are seeing:


We also recommend that you check with your application vendor, or application developer to make sure that your applications are NOT using persistent MySQL connections, which can lead to this issue as well. This should be an easy fix if its the case, but you will need to consult with your developer/application vendor first.

If you need further assistance, please contact our support.

For more information this variable and other MySQL related settings please, check

https://dev.mysql.com/doc/refman/5.0/en/user-resources.html

 This answer was helpful  This answer was not helpful
 Back