mytop — a top clone for MySQL
You should be aware about top if you worked on linux based workstations or servers. This is a simple to use utility which lists all the tasks linux kernal is running and shows run-time information on screen dynamically. If you have not tried it, go run this command on your linux machine and you will start learning about it.
it shows you various stats about a running process like CPU usage, memory usage, user, process id etc, You can also change the view by choosing required columns. You can go through the manual pages of top by man top.
I tried this similar utility called mytop which works for MySql and shows you stats about threads accessing Mysql DB on your machine/server just like top does for linux. It uses SHOW STATUS and SHOW PROCESSLIST commands to get performance data of Mysql server. Installation and usage details can be found at http://jeremy.zawodny.com/mysql/mytop/.
There are some dependencies which are required for installation (mostly perrl modules). Here is a screen shot of mytop running:
mytop can used for monitoring the DB connections and checking their performances.
Note: Make sure you have root privileges before installation of this tool.
Most Commented Posts
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
No comments yet.
Leave a comment