[BBLISA] BBLISA July 14 meeting: Using MySQLtuner 2.0 to monitor and improve mysql performance
John P. Rouillard
rouilj at cs.umb.edu
Thu Jul 8 15:38:33 EDT 2010
Hi all:
I am pleased to announce our Wednesday July 14th BBLISA speaker will be:
Sheeri K. Cabral (of The Pythian Group)
She will be presenting:
Using MySQLtuner 2.0 to monitor and improve mysql performance
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.
We will be in room E51-149 at MIT staring at 7PM, with the
presentation starting at 7:30. See:
http://www.bblisa.org/directions.html for detailed directions to E51.
Mark this in your calendars and I hope to see you there.
Also as Adam announced we will have some door prizes, so for anybody
doing some construction work and in need of a door, feel free to stop
by and enter 8-).
--
-- rouilj
John Rouillard
More information about the bblisa
mailing list