Understanding the Role of IO As a Bottleneck

Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.38, 8 ratings)

This talk is aimed at beginner-intermediate DBAs looking to understanding the role of IO (disks, SSDs) as part of the bigger picture of system performance.

We start by looking at how buffered IO works, and what the difference is between writing and syncing, and then we look at interpreting output from Linux diagnostic tools such as iostat under some typical workloads (read heavy, write heavy, data fits in buffer pool versus does not).

Once we’ve mentioned which situations IO is a problem, we look at some of the common options available to improve the situation – RAID, Raid controllers with battery backed write caches and SSDs.

Also explained will be when to enable options like innodb_flush_method=O_DIRECT, and what last gallant efforts (if any) you can make if you are IO bound but can’t yet upgrade hardware.

Photo of Morgan Tocker

Morgan Tocker

Percona, Inc.

Morgan is the Director of Training at Percona, Inc. His interests in MySQL include Performance Tuning, scalability and High Availability. He is a regular speaker on these topics in the United States and Canada.

Before joining Percona, Morgan worked as a Technical Instructor for MySQL (and then Sun Microsystems) in Canada where he taught courses on High Availability, Performance Tuning and Database Administration. He has also previously worked in the MySQL Support Team, and provided DRBD
support.

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