MySQL Quick Tip

MySQL Quick Tip

If you need to monitor a MySQL server in order to see what is happening, but you haven’t developed any monitoring solutions you can use this to grab information from the mysql server.

How to grab the status and show how many “Com_inserts” are happening every 10 seconds:

> mysqladmin ext -ri10 | grep "Com_insert "


Show how many Connections are happening every 5 seconds:

> mysqladmin ext -ri5 | grep "Connections "


Sometimes you may need to add –user and –password depending on your setup.
Show the processlist ever 30 seconds:

> mysqladmin proc -ri30 --user=root --password=xxxxxx


For more information on mysqladmin and it’s options please see…
http://dev.mysql.com/doc/refman/5.1/en/mysqladmin.html