Mytop Screenshot mytop - a top clone for MySQL

About

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.

Links

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.

Testimonials

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.

News

Version 1.9.1 Was released by Mark Grennan on www.mysqlfanboy.com with more fixes and updates.

May 28, 2010

Version 1.8 Was released by Mark Grennan on www.mysqlfanboy.com and has lots of fixed and updates.

March 29, 2009

Version 1.7 Was release by Jeremy on GitHub and has some updates for 64x systems and Mysql 5.0

February 16, 2007

Version 1.6 is released. Thanks to a patch from Jeffrey Friedl, it allows for passwords that contain spaces.

August 4th, 2003

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.

April 17, 2003

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.

October 28, 2002

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.

April 27, 2002

Version 1.0 is released. It contains many bug fixes and a few enhancements. See the Changes file for full details.

July 8th, 2001

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.

July 7th, 2001

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.

May 9th, 2001

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.

Date Unknown

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.

November 24, 2000

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.

August 10, 2000

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.

July 15, 2000

Version 0.2 (stable) released. Announcements going to MySQL mailing list and Freshmeat.

July 10, 2000

Version 0.1 announced on the mysql@lists.mysql.com mailing list.