* Perl 5.005 or newer * Getopt::Long * DBI and DBD::mysql * Term::ReadKey from CPAN
Most systems are likely to have all of those installed---except for Term::ReadKey. You will need to pick that up from the CPAN. You can pick up Term::ReadKey here:
And you obviously need access to a MySQL server (version 3.22.x or 3.23.x) with the necessary security to run the SHOW PROCESSLIST and SHOW STATUS commands.
If you are a Windows user, using ActiveState's Perl, you can use PPM (the Perl Package Manager) to install the MySQL and Term::ReadKey modules.
Optional Color Support
In additon, if you want a color mytop (recommended), install Term::ANSIColor from the CPAN:Once you do, mytop will automatically use it. However, color is not yet working on Windows. Patches welcome. :-)
Optional Hi-Res Timing
If you want mytop to provide more accurate real-time queries-per-second statistics, install the Time::HiRes module from CPAN. mytop will automatically notice that you have it and use it rather than the standard timing mechanism.Platforms
mytop is known to work on:* Linux (2.2.x, 2.4.x) * FreeBSD (2.2, 3.x, 4.x) * Mac OS X * BSDI 4.x * Solaris 2.x * Windows NT 4.x (ActivePerl)If you find that it works on another platform, please let me know. Given that it is all Perl code, I expect it to be rather portable to Unix and Unix-like systems. Heck, it might even work on Win32 systems.