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.