Watch

MySQL Full Processlist - Watch live every 0.5 seconds (from Command-Line)

Submitted by Gast (nicht überprüft) on Di, 02/02/2021 - 19:21

Watch MySQL full-processlist every 0.5 seconds :


while : ; do mysql -u MY_USERNAME --password='MY_PASSWORD' -e "show full processlist"; sleep 0.5; done 

 

Save full-processlist to log


while : ; do mysql -u MY_USERNAME --password='MY_PASSWORD' -e "show full processlist"; sleep 0.5; done >> mysql-proc.log