1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Understand the limits of simultaneous connections to MySQL / MariaDB
This guide explains the limitations applied to simultaneous connections to a MySQL database of Web Hosting.
MySQL simultaneous connection limits
MySQL always has limits on simultaneous connections to ensure that the server runs reliably, securely, and efficiently while effectively using the available system resources.
This limitation helps to prevent the MySQL server from being overloaded to the detriment of other websites hosted on the server.
Once this limit is exceeded, new connections are impossible and the following message appears: 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 bypass it easily by creating several MySQL database users for the different scripts of a website.
No connection limit per user per hour
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 Infomaniak hosting.
Unlike other hosts, you are not at risk of receiving an error message like this: SQL Error : 1226 User 'data_forum' has exceeded the 'max_questions' resource.