Hack MySQL

mysqlreport v2.7 released

without comments

mysqlreport v2.7 has been released. This version sports the following changes:

  • Option “password” in ~/.my.cnf now recognized (used to be that only “pass” was recognized)
  • Options host, port, and socket now recognized in ~/.my.cnf
  • Given those two changes, the order of option precendece is such that ~/.my.cnf is read first, then command line options override ~/.my.cnf options, and if nothing else default values are assigned
  • –all actually shows all reports now (i.e. no more need to –all –tab)
  • Like mytop, mysqlreport tries to connect via a socket first, otherwise it tries via a network connection

Thank you to those who provided patches for these changes, although I wound up writing the mods myself for various reasons. To those who wanted /var/lib/mysql/mysql.sock to be the default socket, I decided instead to stay with /var/run/mysqld/mysqld.sock because this is the Debian default and (last I heard) mysqlreport is part of the MySQL Debian package so it takes precedence. For /var/lib/ sock’ers (e.g. Red Hat), you can now add socket=/var/lib/mysql/mysql.sock to ~/.my.cnf.
Also thanks to Baron Schwartz (xaprb) for his kind words and praise for mysqlreport, and my apologies to Herald and others who I told I’d fix the pass/password thing “soon” but “soon” became many weeks.

Written by Daniel Nichter

October 22nd, 2006 at 7:53 pm

Posted in MySQL,mysqlreport