The sleep tag has no wiki summary.
0
votes
1answer
39 views
Idle connection plus schema-modifying query causing locked database
As part of our automated deployment process for a web app running on a LAMP stack, we drop all our triggers and stored procedures and recreate them from source control. It turns out there was a hidden ...
0
votes
1answer
55 views
Sleep Processes are Running Longer Than Allowed
From time to time my mysql server will run into a "too many connections" error. I believe part of the problem is large amount of sleep processes that are running, some over 1000 seconds.
When ...
1
vote
2answers
188 views
MySQL: many Sleep processes
I've queried SHOW processlist as root after a server restert, and got a long list of Sleep threads:
+-----+-------------+-----------------+---------+---------+------+-------+------------------+
| Id ...