troubleshooting Question

mysql: too many connections : sleep connections

Avatar of djsoltan
djsoltan asked on
DatabasesMySQL Server
9 Comments1 Solution3691 ViewsLast Modified:
hi, we recently started getting the error msg " too many connections " on our pages with data generated from mysql.
i went to whm and checked the mysql processes and i see alot of processes for the db (soltan_events) that are sleep...
does this look normal? i think something is wrong here,,, can anyone help and give advice?

here is a sample from mysql processes

690      soltan_events      localhost      soltan_events      Sleep      2975            NULL
4165      soltan_events      localhost      soltan_events      Sleep      8449            NULL
5053      soltan_events      localhost      soltan_events      Sleep      1001            NULL
6745      soltan_events      localhost      soltan_events      Sleep      8306            NULL
10602      soltan_events      localhost      soltan_events      Sleep      559            NULL
11638      soltan_events      localhost      soltan_events      Sleep      1036            NULL
11877      soltan_events      localhost      soltan_events      Sleep      1022            NULL
14312      soltan_events      localhost      soltan_events      Sleep      2962            NULL
16702      soltan_events      localhost      soltan_events      Sleep      2964            NULL
19478      soltan_events      localhost      soltan_events      Sleep      1212            NULL
21727      soltan_events      localhost      soltan_events      Sleep      7465            NULL
24498      soltan_events      localhost      soltan_events      Sleep      954            NULL
26481      soltan_events      localhost      soltan_events      Sleep      1195            NULL
27657      soltan_events      localhost      soltan_events      Sleep      991            NULL
34192      soltan_events      localhost      soltan_events      Sleep      1668            NULL
43058      soltan_events      localhost      soltan_events      Sleep      5651            NULL
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros