Projects / mytop

mytop

mytop is a Perl program which allows you to monitor MySQL servers by viewing active threads, queries and overall server performance numbers.

Tags Database Front-Ends Networking Monitoring
Licenses GPL
Operating Systems Windows Windows POSIX
Implementation Perl

Tweet this project Short link

Rss Recent releases

  • Rrelease-mid
  •  21 Feb 2007 05:06
  • Rrelease-after

Changes: Support for passwords with embedded spaces was added.

  • Rrelease-mid
  •  04 Aug 2003 10:51
  • Rrelease-after

Changes: A revamped display, password hiding, better query cache stats, and various bugfixes.

  • Rrelease-mid
  •  29 Oct 2002 04:54
  • Rrelease-after

Changes: Various bugs were fixed, and query cache stats from MySQL 4.x were added.

  • Rrelease-mid
  •  29 Apr 2002 00:58
  • Rrelease-after

Changes: Fixed various display bugs, added new sorting and filtering options, enhanced the real-time statistics, and added the ability to EXPLAIN a query.

  • Rrelease-mid
  •  08 Jul 2001 01:53
  • Rrelease-after

Changes: Added a Queries Per Second (qps) mode for displaying the number of queries executed each second, in real time. It is now packed as a "normal" Perl package for the first time.

Rss Recent comments

Rcomment-before 03 Jul 2009 15:36 Rcomment-trans JamesBromberger Rcomment-after

When running against MySQL 5.4.x, it seems that the number of SQL queries is no longer stored against the "Questions" variable, but against "Queries"; this breaks the Queries and Quereies Per Second fields in MyTOP.

Rcomment-before 17 Jun 2009 20:47 Rcomment-trans robfico Rcomment-after

With the release of MySQL 5.0.83, mytop no longer logs queries except for its own queries... It worked in 5.0.67.

Rcomment-before 08 Apr 2009 16:11 Rcomment-trans kernow9 Rcomment-after

The latest cpanel update (upcp) causes Mytop to fail:
[~]# mytop
Error in option spec: "long|!"

To work around this, edit /usr/bin/mytop
and search for "long|!" then comment out the GetOptions line "long|!" => \$config{long_nums},

Rcomment-before 11 Mar 2009 08:27 Rcomment-trans chorny Rcomment-after

CPAN
Please update it on CPAN also - it is convenient to install it with CPAN client.

Rcomment-before 22 Dec 2005 16:28 Rcomment-trans laxamar Rcomment-after

Have a patch for Longer Ids
I modified the original mytop to dynamically adapt to longer Ids. Please let me know where to post the patch.

Ad8cc32732b24e324e5742a2150d6093_thumb

Project Spotlight

BugHotel Reservation System

A hotel booking and accounting package.

No-screenshot

Project Spotlight

Class Library for Numbers

A C++ library for computations with all kinds of numbers.