Linux - monitor MySQL Tools

$ mysql -u admin -p 123456
mysql> show status;

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance
http://jeremy.zawodny.com/mysql/mytop/

$ mytop -u admin -p 123456
$ mytop -u admin -p 123456 -d phpbb

You can store this information in ~/.mytop file:

vi ~/.mytop

Add config text as follows:

user=admin
pass=123456
host=mysql0.hosting.some.com
db=imail
delay=10
port=3306
socket=
batchmode=0
header=1
color=1
idle=1


mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete.
mkill (MySQL kill) monitors a MySQL server for long running queries and kills them after a specified time interval. Queries can be selected based on regexes on the user, host, command, database, state and query.
http://mtop.sourceforge.net/

innotop is designed to monitor InnoDB transactions and internals, replication status, deadlocks, general queries and status values, and much more.
http://sourceforge.net/projects/innotop/

Comments