Monitor the queries that are executed by MySQL

Valic —  October 19, 2011 — 1 Comment

Watch is a very useful command to run another command periodically.
This is useful for monitoring queries that are causing your server to block.
- n 1 – is the number of secconds between queries.

watch -n 1 mysqladmin --user=root --password=yourpassword processlist

Valic

Posts Twitter Facebook

Editor in Chief at Debian-Tutorials, Linux enthusiast.

One response to Monitor the queries that are executed by MySQL

  1. Very niece info, thanks for share, very useful blog

Leave a Reply