mytop - a top clone for MySQL
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 <Jeremy@Zawodny.com> 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
ports collection. The maintainer seems to keep it
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.
Was released by Mark Grennan on www.mysqlfanboy.com with more fixes and updates.
May 28, 2010
Was released by Mark Grennan on www.mysqlfanboy.com and has lots of fixed and updates.
March 29, 2009
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
August 4th, 2003
Version 1.4 is released. It
several new features, including a revamped display at the top of
the screen. See the Changes file for more
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
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.
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.
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
firstname.lastname@example.org mailing list.