BBLISA was founded in July 1992 to provide a forum for meetings and presentations of interest to system and network administrators in Boston, MA, and the surrounding areas.

While "LISA" stands for Large Installation System Administration, BBLISA is for administrators of both large and small networks.

Membership in the group is free and becoming a member is as easy as subscribing to one of our mailing lists.

The name Back Bay LISA was adopted after the sister organization "Bay LISA", in the San Francisco bay area. Back Bay is an area of Boston, and Boston being back east and also on a bay made the name seem appropriate.

We have a list of sites that are of interest to System Administrators. LOPSA-NJ PICC discounts now available!

Wednesday, September 8 2010

Using MySQLtuner 2.0 to monitor and improve mysql performance

Sheeri K. Cabral

With help from Major Hayden, mysqltuner's original author, Sheeri K. Cabral of the Pythian Group has modified mysqltuner to be more comprehensive, to output information and to have a "spreadsheet" mode where the results of mysqltuner are outputted as a single column, so that you can easily compare subsequent runs of the modified mysqltuner -- for example, running it monthly or weekly to see how performance is progressing (or degrading). There is also a truly offline mode that requires no database connectivity where files containing the output of SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES are used. This talk will go through how the the modified mysqltuner works including how easy it is to change what is checked and the thresholds, so that you can easily do one-off sanity checks as well as regular monitoring.

Sheeri K. Cabral (The Pythian Group) is a noted MySQL community activist who recently wrote The MySQL Administrator's Bible.
Keep up with her MySQL writings at http://www.pythian.com/news/author/sheeri/.

MIT E-51, Room 149
7:00  Introductions and announcements
7:30 - 9:00 Presentations