Date: 11/18/07 (Java Web)    Keywords: mysql, sql

Monitoring MySQL queries is a favorite pastime of MySQL administrators especially for performance reasons. Here is a simple bash script to monitor long running MySQL queries in realtime using the ubiquitous ’show processlist’: #!/bin/bash while [ 1 ] do mysql -N -u root -ppassword -e 'show processlist' |grep -v 'show processlist' [...]

Source: http://blog.taragana.com/index.php/archive/monitoring-mysql-queries-using-bash-script/