General Support
2 fplanque Feb 05, 2019 23:35
1 chanakyadas Feb 05, 2019 08:15
Website: xchanges.org
We have been continuously bugged with this error over the last one year.
Additional information about this error:
MySQL error!
Error establishing a database connection!
(mysqli_real_connect(): (42000/1203): User xchange3_b22823 already has more than 'max_user_connections' active connections)
Are you sure you have typed the correct user/password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
It gets fixed after a while, but we are concerned as sometimes this error comes up in peak hour when most students/faculty are browsing our educational journal.
Can you please help us fix this issue?
Best regards,
Chanakya Das
Technical Editor
Xchanges.org
3 poorboy2 Feb 17, 2019 22:07
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
It gets fixed after a while, but we are concerned as sometimes this error comes up in peak hour when most students/faculty are browsing our educational journal.
Makes sense.
You can ask your hosting to increase max_user_connections and either they will or they will suggest you upgrade to a higher plan.
Bottom line is that it the limit set by your webhost and in busy times, your site is exceeding that limit. Some hosts set it as low as 10 or 25 for their economy plans.
4 joeest Mar 09, 2019 13:28
Have you configured more connections on MySQL config file on the server? If you don't have access of the server, kindly escalate this issue to your web host and request them to allow more connections.
You did not mention your webhost :(
Everything is already written in the error message: User xchange3_b22823 already has more than 'max_user_connections' active connections
Contact your webhost and upgrade to a more powerful hosting plan than can accept more simultaneous users on your website.