Level 13
You may have web clients with MySQL connections just hanging around. Do you have SSH access?
1 like
Jun 16, 2015
4
Level 3
[ WatchMySQL Alert ] You have exceeded your MySQL concurrent connection limit!
root @cpanel.myhostingserver.com">root@cpanel.myhostingserver.com 9:31 AM (27 minutes ago)
to me
This message is to alert you that you have exceeded your concurrent MySQL connection limit. Please review the details below
User: Userid Domain: mydomain MySQL Connection Limit: Current MySQL Connections: 65
how to control it. Above message is come for me from my shared web hosting server. How control from attach outside client on my database ? help me thanks for advance
Level 47
If it's a shared host, try asking via support. Otherwise with out explanation of what your running your stuck at the mercy of the bost.
1 like
Level 47
I remember running into a similar issue using azure (Ms cloud hosting) as MySQL is run by a third party. They allow only 10 connections with out paying extra. With a few users online at once it would hit that limit. Even with pro ensuring connections are closed after each query it would still take a few seconds for the connection to release and be back into the available pool.
I have updated other devs crap code that the queries where not properly eager loaded and would be well over 30plus connections/separate queries on a single page. Even though, shared hosting is only good imo for personal sites with a hand full of visits a day.
1 like
Level 3
Please or to participate in this conversation.