The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
58 views

what's practical example / use case SELECT SLEEP() for DBA

I don't know how to use SELECT SLEEP(). It looks like a dirty hack. I found an interesting question How and when to use SLEEP() correctly in MySQL?. The answer is developer oriented: If you don't ...
1
vote
2answers
547 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 ...
1
vote
1answer
248 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 ...
2
votes
2answers
1k 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 ...