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.

Links

• README – what is it, how to install
• Documentation – read before you ask
• Changes – see what changed in each version
• Download – a tar.gz file
• Screenshot – or just look to the right
  
  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.