Questions tagged [sleep]
The sleep tag has no usage guidance.
10 questions
0
votes
1
answer
36
views
Sleeping for a random amount of time in a stored procedure
A vendor application we're using utilizes multiple processes (not threads) spread across multiple computers, one for each processing core available. When asked for a batch of calculations, the ...
- 136
0
votes
1
answer
1k
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 ...
- 200
1
vote
5
answers
14k
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 ...
1
vote
0
answers
686
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 ...
- 111
1
vote
1
answer
152
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 ...
3
votes
1
answer
622
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 ...
- 233
1
vote
1
answer
2k
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 ...
- 2,558
2
votes
2
answers
2k
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,095
1
vote
1
answer
1k
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 ...
- 115
3
votes
2
answers
5k
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 ...
- 11.9k