1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
MySQL: Maximum number of simultaneous connections
This guide explains the limitations applied to simultaneous connections to a MySQL database.
Simultaneous MySQL connection limits
Each database user is limited to 38 simultaneous MySQL connections. This limitation helps to prevent overloading the MySQL server to the detriment of other sites hosted on the server.
Once this limit is exceeded, new connections are not allowed, and the following message displays: "User has already more than 'max_user_connections' active connections" or "Warning: mysql_connect(): Too many connections in /home/www/... "
This limit is rarely reached in practice, and it is possible to get around it easily by creating multiple MySQL database users for the different scripts on a site.
Infomaniak does not limit the number of MySQL connections per user per hour: the values MAX_QUERIES_PER_HOUR / MAX_UPDATES_PER_HOUR / MAX_CONNECTIONS_PER_HOUR are not present on our hostings. Unlike other hosts, you won't get an error message like this one: "SQL Error : 1226 User 'data_forum' has exceeded the 'max_questions' ressource".