MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)

Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.38, 8 ratings)

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 II: Intermediate MySQL Variables

  • Locking variables
  • MyISAM basic variables
  • MyISAM FULLTEXT variables
  • MyISAM repair variables
  • MyISAM index cache variables
  • INSERT DELAYED variables
  • Basic transaction variables
  • InnoDB basic variables
  • InnoDB performance tuning variables
  • InnoDB concurrency variables and how the InnoDB ticketing system works
  • InnoDB deadlock and semaphore variables
  • InnoDB File I/O variables
  • Global File I/O variables
  • OS-specific variables (for Windows, Linux, Solaris)
  • OS-related variables (relating to file descriptors, thread handling, etc)
  • Network-related variables (including timeouts)
  • Profiling variables
Photo of Sheeri K. Cabral

Sheeri K. Cabral

Mozilla Foundation

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.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/20/2010 4:50am PDT

Video is at: part 2, before break: www.youtube.com/watch?v=RKw... part 2, after break: www.youtube.com/watch?v=WfO...

See also part 1 at en.oreilly.com/mysql2010/pu...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/20/2010 4:50am PDT

Video is at: part 2, before break: www.youtube.com/watch?v=RKw... part 2, after break: www.youtube.com/watch?v=WfO...

See also part 1 at

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/13/2010 9:23am PDT

slides are at http://bit.ly/my10vars2

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

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

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.