Recent Topics

MySQL error!

Started by on Feb 05, 2019 – Contents updated: Feb 17, 2019

Feb 05, 2019 08:15    

MySQL error!

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

Affected website URL :http://www.xchanges.org/

Feb 05, 2019 23:35

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.

Feb 17, 2019 22:07

@chanakyadas

https://dev.mysql.com/doc/refman/8.0/en/user-resources.html

https://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-3-6-questions-problems-and-troubleshooting/226351-user-xxxx-has-already-more-than-max-user-connections-active-connections

https://support.hostgator.com/articles/specialized-help/technical/max-user-connections-vs-too-many-connections

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.


Form is loading...

Free blog engine – This forum is powered by b2evolution CMS, a complete engine for your website.