Monitoring MySQL with MyTop

By | | Open Source

0

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).

Written By:

Blane Warrene

Blane is a writer and researcher focusing on Apple and Open Source technologies. Prior to this, he helped found a commercial software and consulting venture, and worked in the financial services sector as a director of technology and in varying technical roles. Blane maintains Open Sourcery: SitePoint's Open Source Blog.

Website
>> More Posts By Blane Warrene

 

Comments on this entry are closed.