[BBLISA-announce] October BBLISA Meeting tomorrow: Using MySQLtuner 2.0 to monitor and improve mysql performance
John P. Rouillard
rouilj at cs.umb.edu
Tue Oct 12 13:29:20 EDT 2010
Sheeri Cabral will present a talk on using using MySqltuner 2.0 to
monitor and tune your MySQL installation" tomorrow: Wednesday, October
13 2010. NOTE we are not in our usual room, but are on the third floor
of building E51 in room 372. Also there will be door prizes, so if you
need a door you will want to be here 8-).
Using MySQLtuner 2.0 to monitor and improve mysql performance
Speaker: 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
MIT E-51, Room 372 *** Note the ROOM CHANGE to the third floor
7:00 Introductions and announcements
7:25 Door prizes
7:30 - 9:00 Presentations
I am out of town, so Adam M. will be doing the MC honors.
My employers don't acknowledge my existence much less my opinions.
More information about the bblisa-announce