Blog Post RSS ?

Blogs » Open Source » Monitoring MySQL with MyTop
« Photoshop Blending Modes: Dissolve
Adjusting to QMail »
 

Monitoring MySQL with MyTop


  • Save to
    Del.icio.us

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

This entry was posted on Friday, July 30th, 2004 at 3:39 pm, contains 95 words, and is filed under Open Source. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed. The views and opinions in this blog post are those of its author.

Sponsored Links

Leave a response

You are not logged in, log in with your SitePoint Forum username and password.

-OR- Post Anonymously

* Make sure any code samples are escaped (i.e. ‘<b>’ becomes ‘&lt;b&gt;’).

If not logged in, your comments will be placed in a moderation queue. This means your comment may not appear until one of our moderators approves it.

Your Blogmaster is...

Blane Warrene

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.

Subscribe

SitePoint Newsletters

Get all the latest tips by signing up to all of SitePoint’s informative newsletters.

HTML   Plain

SitePoint Blogs

SitePoint Marketplace

Buy, Sell, Trade

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

Logo Design, Web page Design and more!

99designs

  • Custom logo designs created ‘just for you’.
  • Pick the design you like best.
  • Only pay if you’re satisfied with the result.

It's Back!

Posting Code Snippets

Feel free to enter code snippets into your comments in the following format.

Marking Up Your Code
<pre>
<code class='html'> 
code snippet 
</code>
</pre>

Be sure to escape any HTML snippets (i.e. '<' becomes '&lt;' ).

Supported language classes include:

  • XML, HTML, XSLT and any other XML style code
  • CSS
  • C#
  • VB & VB.NET
  • Delphi, Pascal
  • JavaScript
  • PHP
  • Python
  • SQL
FREE PDF with any printed book!