Mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, 4.x and 5.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. If you install Time: :HiRes, you'll get good real-time queries/second stats. As of version 0.7, it even runs on Windows (somewhat). The original development was done by Jeremy D. Zawodny <> and is well know after being published in the book, High Performance MySQL.
I would be amiss if I didn't say something about innotop. Some consider this a predecessors to mytop. It is of you are using InnoDB. I still find mytop useful. More than half of my tables are MyISAM.
mytop is listed on freshmeat so that you can easily subscribe and be notified when new versions are released. FreeBSD users can find mytop in the ports collection. The maintainer seems to keep it relatively current.
From Kevin Old the MySQL mailing list:
I ran across this tool the other day and it is awesome. Basically it is like the top utility for *nix, but it's for mysql. It basically gives you a live look into the database and what queries it's processing, etc in real time.
From Daniel the MySQL mailing list:
mytop is very wicked. It helps monitor the queries.
Version 1.6 is released. Thanks to a patch from Jeffrey Friedl, it allows for passwords that contain spaces.
Version 1.4 is released. It contains several new features, including a revamped display at the top of the screen. See the Changes file for more details.
Version 1.3 is released. It contains many small bug fixes and a new "command status" mode. See the Changes file for a more complete list.
Version 1.2 is released. It contains many bug fixes and a few enhancements. Notably, it adds stats for the query cache in MySQL 4.x. See the Changes file for full details. Version 1.1 was only used by a few testers.
Version 1.0 is released. It contains many bug fixes and a few enhancements. See the Changes file for full details.
Version 0.9 (stable on Unix, beta on Windows) released. No bugs fixed. Set $0 to `mytop' so that it looks nice in top, ps, and similar tools. This also keeps some of the command-line args away from prying eyes. I also remembered to put the README file in the tarball this time. Not announced.
Version 0.8 (stable on Unix, beta on Windows) released. No bugs fixed. A new Queries Per Second (qps) mode has been added. In this mode, mytop will write out one integer per second. The number written reflects the number of queries executed by the server in the previous one second interval. Announced on Freshmeat and the MySQL mailing list. Uploaded to CPAN for the first time.
Version 0.7 (stable on Unix, beta on Windows) released. Some column formatting bugs fixed. Added basic support for runnin on Windows with ActiveState's Perl. Announced on the MySQL mailing list and Freshmeat.
Version 0.6 (beta) produced. This version was never distributed beyond a few computers at Yahoo. There were numerous things to test and a few minor bugs fixed.
Version 0.5 (beta) released. Added filtering based on a thread's owner (user) and the database to which it is connected (`u' and `d' hotkeys). Also finally implemented the fully query info (`f' hotkey). Announced on the MySQL mailing list only.
Version 0.4 (stable) released. Added a few new hotkeys and command-line parameters. Fixed display on small terminals. Announced via Freshmeat and the MySQL mailing list.
Version 0.3 (beta) released. Added experimental color support, killing of threads, improved command-line options, batch mode, counter reset, and more. Announced via MySQL mailing list and Freshmeat.
Version 0.2 (stable) released. Announcements going to MySQL mailing list and Freshmeat.
Version 0.1 announced on the firstname.lastname@example.org mailing list.