BBLISA: Back Bay Large Installation System Administration

[Home] [Meetings] [Directions] [Calendar] [Mailing Lists] [Links] [Contacts]

Wednesday, September 8 2010

MySql

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/.




Future Events Past Events
Wed, May 12, 2010
Using IPv6
Daniel Hagerty
Daniel has been using IPv6 for fun (and to get things done) for quite some time. Come learn what has and has not worked for him. Details of his personal dual-stack IPv6 setup will be presented as well as other experiences.
Wed, 14 Apr 2010
"Building 16 systems in 16 minutes with xCAT"
Ali Tayarani
Ali Tayarani will discuss how we use xCAT to manage several hundred hosts in our general-purpose LSF-based compute cluster.
"Redefining Compute Nodes and Provisioning"
John Hanks
John Hanks will discuss his grand vision for the future (stateless compute nodes managed with Perceus), exemplified by our new genome-sequencing GridEngine cluster.

Wed, 10 Mar 2010
"How to Interview a System Administrator"
Adam Moskowitz
This will be a shortened version of Adam's LISA tutorial. The full description can be on the LISA 2007 web site.

Wed, 10 Feb 2010
(no meeting)

Wed, 13 Jan 2010
“I Got My Jet Pack and I'm Still Not Happy”
David Blank-Edelman
slides (PDF, 11.75MB)

Wed, 9 Dec 2009
Thirty Minute Tools
John Rouillard (and others)

Wed, 11 Nov 2009
LISA Recap
Adam Moskowitz

Wed, 14 Oct 2009
(was there a meeting?)

Wed, 09 Sep 2009
“Log Analysis with the Simple Event Correlator”
John P. Rouillard

Wed, 12 Aug 2009
Everything I Know About Sysadmin I Learned in the Back of an Ambulance
John P. Rouillard

webmaster at bblisa dot org