acouple times i have notice the command sleep, with times like 200 or even 1700, what might be the cause of this? anyone know?
Sleep()
in the mysql?
SQL query: SHOW PROCESSLIST
3110077 db_usr1 localhost db_db1 Sleep 200 --- ---
anyone?
SLEEP(duration) Sleeps (pauses) for the number of seconds given by the duration argument, then returns 0. If SLEEP() is interrupted, it returns 1. The duration may have a fractional part given in microseconds. This function was added in MySQL 5.0.12.
SLEEP(duration)
Sleeps (pauses) for the number of seconds given by the duration argument, then returns 0. If SLEEP() is interrupted, it returns 1. The duration may have a fractional part given in microseconds. This function was added in MySQL 5.0.12.
from the MySQL manual : sleep()
is that something that is done automatically? cuz i dont ever use any sleep command