1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Understanding simultaneous connection limits in MySQL / MariaDB
This guide explains the limitations applied to simultaneous connections to a MySQL database in Web Hosting.
Limitations of Simultaneous Connections to MySQL
MySQL always has limitations on simultaneous connections to ensure that the server operates reliably, securely, and efficiently while effectively utilizing available system resources.
This limitation helps avoid overloading the MySQL server at the expense of other sites hosted on the server.
Once this limit is exceeded, new connections are not possible, 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 easily bypass it by creating multiple 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 will not risk getting an error message like this: SQL Error : 1226 User 'data_forum' has exceeded the 'max_questions' resource.