High-throughput MySQL

Mark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)
Average rating: ****.
(4.06, 18 ratings)

Commodity servers are available with 8 to 32 CPU cores and 10,000 to 100,000 IOPs. MySQL has some work to do to use this capacity efficiently. The database engineering team at Facebook is one of several groups in the MySQL community working to make MySQL faster on hardware like this.

We will describe bottlenecks encountered at Facebook and provide performance results for the changes. We will describe the SQL that reproduces the problems, symptoms from monitoring that identify the problems and the source code in MySQL that causes the problems.

Work done by the Facebook team includes changes to improve thread scheduling, reduce mutex contention, make mutexes more efficient and identify the sources of disk IO.

Photo of Mark Callaghan

Mark Callaghan

Facebook

Mark leads the MySQL engineering team at Facebook. The team makes MySQL better for a large and critical deployment. The team writes about their work at MySQLatFacebook and publishes patches for MySQL at launchpad.

He previously lead the MySQL engineering team at Google. The team published a popular patch for MySQL that included semi-sync replication, user and table monitoring via SHOW TABLE_STATISTICS and USER_STATISTICS, SMP and IO performance patches for InnoDB, global transaction IDs for replication, row-change logging, transactional replication and many bug fixes.

Prior to Google Mark worked at Identity Engines, Oracle and Informix on database internals. Mark holds an M.S. degree in Computer Science from the University of Wisconsin-Madison. He occasionally writes about MySQL at mysqlha.blogspot.com.

Photo of Ryan Mack

Ryan Mack

Facebook

Ryan is a member of the database engineering team at Facebook.

Photo of Ryan McElroy

Ryan McElroy

Facebook

Ryan is a member of the database engineering team at Facebook.

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/21/2010 8:00pm PDT

Video for this presentation is online at www.youtube.com/watch?v=OOm...

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