HelioHost Posted February 23, 2019 Posted February 23, 2019 Username: coco4, Server: Tommy, Main domain: greifswalder-bachwoche.heliohost.org Dear Heliohost support, Since this morning we are having again a problem on our website greifswalder-bachwoche.heliohost,org (coco4) with the database connection. The error reads: User coco4_mysql_adm already has more than 'max_user_connections' active connectionsUser coco4_mysql_adm already has more than 'max_user_connections' active connections We happen to see this error sometimes (but rarely). Can you tell, if there is a reason for this? I had a quick look on the database configuration webpage. Next to our database there was another database called "information_schema". Do you know, if this database can be deleted, or is it necessary? It seems to me that there is a huge data traffic to and from the MySQL server. We have just a small website. This cannot result in such huge amounts of data traffic (8gb since 13h?). Do you have an explanation for this observation? Thank you, Kind regards, Volker Gesendet: Montag, 28. Januar 2019 um 09:04 Uhr Von: "Volker Schloßhauer" <coco4@gmx.net> An: Heliohost <support@heliohost.org> Betreff: Database issue on our website Dear Heliohost support, Since this morning our website greifswalder-bachwoche.heliohost.org is no longer available. we are encountering an error message . It is a database issue with too many open MySQL connections. The error reads: User coco4_mysql_adm already has more than 'max_user_connections' active connectionsUser coco4_mysql_adm already has more than 'max_user_connections' active connections Is there a possibility to close the open connections? I seldomly saw an error like this. Does it infer that the programmation of our website has some database leaks. Thank you for support! Kind regards, Volker
Krydos Posted February 23, 2019 Posted February 23, 2019 The max_user_connections error is in place to prevent one account from hogging the entire mysql server, and preventing everyone else from being able to access it. We recommend making sure you're closing your mysql connections immediately after you're done using them. Some languages, most notably Java, try to always use persistent connections which quickly results in a lot of those max_user_connections errors. Another thing you can do is write your code to detect max_user_connections errors and automatically try the connection again after a second. This helps hide the error from the end user by having the page take a little longer to load instead of just ending immediately with an error. Information_schema is the database where the information about all the other databases is kept, for example names of a database or a table, the data type of columns, access privileges, etc. It is a built-in virtual database with the sole purpose of providing information about the database system itself. The MySQL server automatically populates the tables in the information_schema. The important thing to remember about the information_schema database is that you can query it, but you cannot change its structure or modify its data. Source: https://www.siteground.com/kb/what_is_the_information_schema_database/ Over the past week your account has only transferred 258 MB of data. That is a pretty standard amount for a small website. This isn't something to be worried about. We offer unlimited bandwidth anyways, and have accounts that consistently transfer more than 100 GB per week.
Recommended Posts