Questions tagged [sleep]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
30 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 ...
1
vote
5answers
5k 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
0answers
362 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
48 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 ...
1
vote
1answer
484 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
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 ...
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
808 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 ...
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 ...