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/
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
Post a Comment