Question : I don’t know how to use SELECT SLEEP(). It looks like a dirty hack. I found an interesting […]
Tag: sleep
Rate-limiting query execution in a batch process
Question : I have a set of queries in my queries.sql file which I am feeding to psql for execution. […]
Debugging sleeping connections
Question : I’m troubleshooting an app that has a lot of sleeping connections to my MySQL (MariaDB) server. I’d like […]
MySQL: many Sleep processes
Question : I’ve queried SHOW processlist as root after a server restert, and got a long list of Sleep threads: […]
Idle connection plus schema-modifying query causing locked database
Question : As part of our automated deployment process for a web app running on a LAMP stack, we drop […]
How to execute MySQL query after 1 minute
Question : I have a query, but I want to call it now and wish it to be executed after […]
Sleep Processes are Running Longer Than Allowed
Question : From time to time my mysql server will run into a “too many connections” error. I believe part […]