Date: Jul 07/08/10 3:38 PM Subject: [BBLISA-announce] BBLISA July 14 meeting: Using MySQLtuner 2.0 to monitor and improve mysql performance From: "John P. Rouillard" 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 _______________________________________________ bblisa-announce mailing list bblisa-announce@bblisa.org http://www.bblisa.org/mailman/listinfo/bblisa-announce