mtop (MySQL top) monitors a MySQL database showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided.
|Tags||Database Front-Ends Monitoring|
|Operating Systems||OS Independent|
Release Notes: A new feature to "fold" selected columns in the main display was added, so you can see more of the WHERE clause. mkill.PL is included, as it was missing from the 0.6.5 distribution.
Release Notes: A minor fix to no longer require a connection to the test database.
Release Notes: The mkill utility was added to watch and kill long running queries based on regex filters. mtop has new options to control how many seconds elapse before a slow query is highlighted.
Release Notes: This release adds new "per second" statistics, a new admin stats page, and the ability to store the configuration in .mtoprc. It fixes several replication-related bugs (to properly show the slave location) and Mac OS X curses/display bugs.
Release Notes: Comments are now stripped from the monitor window. Comments will still appear in the zoom/explain views. Leading spaces were also removed from the display columns.