MyTOP is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL created by Jeremy Zawodny.
For months now I have been adding updates to mytop. 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.
- New ‘!’ command to force fix replication errors.
- Display rows sorted per second.
- Added new ‘Cmd’ column to display the state of the query along with the statement.
- New ‘M’ command to change the [Mode] to ‘status’. This was in the code but covered up by another command.
If you find any bugs or would like to see your own updates added please email me at mark @ grennan.com.
Enjoy!
Tweet
LinkedIn
Grennan.com
Twitter
Are you aware of innotop? It’s way more powerful than mytop.
Link | July 23rd, 2010 at 1:49 pm
Obviously not. Thanks! this is why I write a blog.
It’s funny what you can miss. Both mytop and innotop are included as rpm packages by Redhat but I never found innotop. Having read High Performance MySQL by Zawodny I found mytop and I couldn’t believe how out of date it was. After updating the code I tried to contact him for some time without an answer.
Looks like the code may have come from the same roots. I’ll use innotop for some time see if it fits my needs better. Or maybe I’ll add the think I like into innotop and pass the code along.
Link | July 23rd, 2010 at 3:54 pm
You have the first edition of High Performance MySQL — get the 2nd edition. (I am the lead author.) It’s almost a whole new book :-)
Link | July 24th, 2010 at 10:32 am
Again your right. I was reading my paper back version (first edition) and forgot I even and the 2nd edition on my Kindle.
I’m reading it now. Thanks.
Link | July 25th, 2010 at 2:45 pm
Could you please update the screenshot on http://www.mysqlfanboy.com/mytop/ with the one from this blog post?
Link | August 8th, 2010 at 9:07 am
You might want to update the http://www.mysqlfanboy.com/mytop/ page. It still points only to the 1.8 version of mytop.
Link | November 4th, 2010 at 2:42 pm
Thanks. Done. How do these things slip my me.?!
Link | November 8th, 2010 at 3:02 pm