Questions tagged [sleep]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
2answers
4k 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 ...
2
votes
2answers
1k 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
1k 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
1answer
796 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
0answers
349 views

MySQL import failed with process in 'sleep' state

I'm trying to import a dump ~500MB, ~300 tables using the SOURCE command from withing the MySQL command line environment. Everything seems to go well with tables being created and being filled with ...
1
vote
1answer
473 views

Rate-limiting query execution in a batch process

I have a set of queries in my queries.sql file which I am feeding to psql for execution. But I don't want them to run instantly one after the other: I would like to set some sort of delay - I was ...
1
vote
1answer
45 views

How come website be random slow? Open sleep processes?

My website is randomly very slow by high MYSQL CPU, and I have no idea what the problem is. Hopefully I will come closer to the solution with this post. If I check the mysql processes, I see a lot of ...
0
votes
1answer
21 views

Debugging sleeping connections

I'm troubleshooting an app that has a lot of sleeping connections to my MySQL (MariaDB) server. I'd like to see just what the queries are on these sleeping connections, but when I run SHOW FULL ...
0
votes
5answers
4k views

How to execute MySQL query after 1 minute

I have a query, but I want to call it now and wish it to be executed after few mins and seconds. Please note: I don't want to use SLEEP(), as it 'freezes' the entire database. I want one of the ...