MySQL offers a complex amount of information in commands like SHOW VARIABLES, SHOW STATUS and SHOW ENGINE INNODB STATUS. This 2-part tutorial will mine through the information to show how to use the information to make decisions about performance tuning and capacity planning. Sheeri Cabral of the Pythian group explains all the variables and how to use them in a way that a MySQL newbie can understand and a seasoned MySQL expert will learn something new.
Part I: Basic MySQL Variables
Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and wrote the MySQL Administrator’s Bible (www.tinyurl.com/mysqlbible). She currently works for PalominoDB, a remote database management company
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).
View a complete list of O'Reilly MySQL Conference contacts.