Blog Post RSS ?

Blogs » Open Source » Monitoring MySQL with MyTop
 

Monitoring MySQL with MyTop

by Blane Warrene

This handy little utility was passed on to me by a developer friend and it works much like the standard Linux ‘top’ command does.

MyTop, developed and administered by Jeremy Zawodny, runs from the command line and provides performance monitoring for MySQL server itself and queries/threads executing.

The tool requires just a few Perl modules that dress it up a bit — such as Term::ANSIColor to see the terminal session in color, and Time::HiRes for real-time query/second stats.

It supports numerous Unix-based systems, including Mac OS X, FreeBSD and also has some Windows support (under ActiveState Perl).

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Ping.fm
  • Twitthis

Related posts:

  1. Interactive CLI password prompt in PHP Just a quick tip, since I spent a good hour...
  2. Free Performance with MySQL Table Types Last week, SitePoint launched its second Twitaway, giving away a...
  3. How to Administer a Remote MySQL Database using SSH Tunneling Configuring remote MySQL databases with the command line or phpMyAdmin...
  4. How to Install MySQL Installing MySQL is easier than you think. Craig provides a...
  5. MySQL Cross-Platform Table Naming Craig highlights the biggest potential pitfall of porting your MySQL-based...

Comments are closed.

Sponsored Links

SitePoint Marketplace

Buy and sell Websites, templates, domain names, hosting, graphics and more.

Follow SitePoint on...