We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
New design
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.7.3.5. Max_user_connections error

Mistake "User 'example_db' has exceeded the 'max_user_connections' resource (current value: XX)"Occurs when the limit on the number of simultaneous connections to the database is exceeded. The current limit is displayed in the error text in brackets opposite “current value».

Standard limit values:

  • Shared hosting - 50 (at all tariffs). Attention! If the hosting account exceeds the permissible load, the limit for it can be reduced to bring the load back to normal.
    • Business 2G - 120.
    • 4G business - 180.
    • Business 6G - 200.
    • Business 8G - 200.
    • Business 16G - 200.
    • Business 32G - 200.

You can change the limit only by switching to a higher tariff businesshosting... It should be borne in mind that a simple change of the tariff and an increase in the limit does not guarantee that the problem will be solved. If a site is making too many connections to the database, it is a good idea to first find the root cause of this behavior by examining the site's code. Increasing the limit without analyzing the problem may lead to the fact that the new limit is also quickly exhausted, or other resources (processor or RAM) will be exhausted.

The most common causes of the problem:

  • High consumption of server resources:
    • Consumption of dedicated processor resources by 100%.
    • Consumption of dedicated RAM at 100%.
  • Slow and heavy database queries.
  • Lots of database connections created by site scripts or third-party software.

To remedy the situation, it is worthwhile to initially determine the cause of the problem and take actions to eliminate it:

  1. Check for high load indicators on the graphs resource consumption... If there are high values of resource consumption, then it is worth taking measures to eliminate them, because consequence of high load there may be problems in the operation of all sites in the hosting account.
  2. Large problem requests are recorded and displayed in the hosting control panel in the section “Slow queries". The reason may be either the incorrect compilation of the query, which is already quite difficult from the beginning, or the unoptimized structure of the database. It is worth considering the possibility of optimizing themselves requests and Database.
  3. If the previous two reasons have been verified, but their signs are not observed, it is worth trying temporarily change Password databases, so that new connections are not created. In this case, after a while, all connections will be completed and it will be possible to connect to the database for further maintenance and search for possible causes. If it is difficult to determine what exactly can cause such a problem, then in all scripts and in all software where this database was used with the same user, gradually change the password for connecting to the current one and check for the recurrence of the problem.