Archive for November, 2010
innotop version 1.8.0 released
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.
Longer version:
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).
Getting ready for a new innotop release
It’s been ages since we’ve had an update to innotop, or at least, it’s been a while since the changes were bundled up and released officially. Barring any bug reports against the trunk code, I’m about ready to release more than a year’s worth of improvements to it:
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 enhancements (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:
* 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 the InnoDB plugin wasn't subtracted correctly (issue 38).
* Switching modes and pressing ? for help caused a crash (issue 40).
Products that scale linearly to hundreds of servers
I see this all the time:
[product] scales linearly to hundreds of servers
I haven’t seen a benchmark yet that’s truly a straight line. I would like to see one.
