mytop - a `top' clone for MySQL

http://public.yahoo.com/~jzawodn/mytop/

About

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It runs on most Unix systems which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. As of version 0.7, it even runs on Windows (somewhat).

New in 0.8:

Added a "Queries Per Second" or qps mode. You can enter qps mode by hitting the `m' key. 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.

mytop is now distributed as a true Perl package. There's a normal Makefile.PL, which means it can be installed via the standard mantra:

perl Makefile.PL make make test make install

This should make life a bit easier. It also means that you could install it using the CPAN shell.

Jeremy

MySQL 3.23.29: up 21 days, processed 162,725,767 queries (86/sec. avg)