MyTOP is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL.
UPDATE – I just fond Jeremy did update MyTOP in 2009 and released it on GitHub. He fixed the 64x and 5.x bugs. He also incremented the version number to 1.7. So, I’m bumping my number to 1.8.
Jeremy D. Zawodny wrote the original in 2000 and has continued to update it until 2007. The 1.6 version works on MySQL up to version 4.x.
For weeks now and I’m been working on bringing it up to date. When I started using version 1.6 it worked but didn’t return some data fields. After fixing these bugs I began to ideas for improvements. Here is a quick list of what I have done.
- Added updates for MySQL 5.x.
- Added ‘S’ (slow) highlighting.
- Added ‘C’ to turn on and off Color.
- Added ‘l’ command to change color for long running queries.
- Fixed a few documentation issues.
- Added monitoring for Slave status.
- Added color to Queue hit ratio.
- Added number of rows sorted per second.
- Added a new column to display State of the query. (Sorting, Locked, Updating)
- Added ‘t’ to filter based on State.
How can you use it? I was having a problem with a production system. It has locks creating long delays in MyISAM tables. (Not new.) I used MyTOP version 1.7 (my release) with the ‘t’ command to filter the query state for ‘Locked”. I also use the ‘i” command to reverse the sort order and filter for active connections. I found a “LOCK” run by root on the local host. I then use ‘f’ to display the full query request. I copied it and killed it with the ‘k’ command. Problem solved. You can’t do this with MySQL Administrator, MySQL Workbench or Toad for MySQL.
The color display makes monitoring what is happening easy.
I’m making my updates to MyTOP availible at www.MySqlFanBoy.com/mytop.
Enjoy.
Tweet