Archive for the ‘Innotop’ Category
I often need to watch a server that’s very minimally configured, e.g. has no Perl DBI libraries installed, and I shouldn’t install anything. The following snippet is a quick way to do that:
watch 'mysqladmin proc | grep -v Sleep | cut -b0-130'
Replace 130 by the width of your terminal, naturally.
(Of course, innotop is much more featureful than mytop, but mytop is the essential functionality we’re going for here!)
I’ve started an HTML manual for innotop, a “top” clone for MySQL. It includes screenshots. Right now I only have screenshots for the new U mode, which demonstrates how the User Statistics enhancements in Percona Server can show you which tables and indexes are most used.
I’ve just uploaded the new release of innotop to Google Code. Short version of the changelog: works on MySQL 5.1 with the InnoDB plugin; more efficient; supports Percona/MariaDB USER_STATISTICS data; fixes a bunch of small annoying bugs.
2010-11-06: version 1.8.0 Changes: * Don't re-fetch SHOW VARIABLES every iteration; it's too slow on many hosts. * Add a filter to remove EVENT threads in SHOW PROCESSLIST (issue 32). * Add a timestamp to output in -n mode, when -t is specified (issue 37). * Add a new U mode, for Percona/MariaDB USER_STATISTICS (issue 39). * Add support for millisecond query time in Percona Server (issue 39). * Display a summary of queries executed in Query List mode (issue 26). Bugs fixed: * Made config-file reading more robust (issue 41). * Hostname parsing wasn't standards compliant (issue 30). * MKDEBUG didn't work on some Perl versions (issue 22). * Don't try to get InnoDB status if have_innodb != YES (issue 33). * Status text from the InnoDB plugin wasn't parsed correctly (issue 36). * Transaction ID from InnoDB plugin wasn't subtracted correctly (issue 38). * Switching modes and pressing ? for help caused a crash (issue 40).