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 |
Recent releases
- 21 Feb 2007 05:06
Changes: Support for passwords with embedded spaces was added.
- 04 Aug 2003 10:51
Changes: A revamped display, password hiding, better query cache stats, and various bugfixes.
- 29 Oct 2002 04:54
Changes: Various bugs were fixed, and query cache stats from MySQL 4.x were added.
- 29 Apr 2002 00:58
Changes: Fixed various display bugs, added new sorting and filtering options, enhanced the real-time statistics, and added the ability to EXPLAIN a query.
- 08 Jul 2001 01:53
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.
- All comments
Recent commentsWhen 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.
With the release of MySQL 5.0.83, mytop no longer logs queries except for its own queries... It worked in 5.0.67.
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},
CPAN
Please update it on CPAN also - it is convenient to install it with CPAN client.
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.