Concurrency Control: How it Really Works

Architecture and Technology
Location: Ballroom E Level: Intermediate
Average rating: ***..
(3.00, 1 rating)

InnoDB today is the leading transactional storage engine for MySQL. This presentation describes how InnoDB manages concurrency control, so that users get superior performance and transaction throughput, while the system protects data integrity. We will begin with the basics of transaction management, including a discussion of the ACID (atomicity, consistency, isolation, and durability) properties, and explain various transaction modes, locking, deadlocks, and more advanced topics such as the impact of next-key (gap) locking, referential integrity, XA (distributed transaction management) support and more. While the discussion will focus on the InnoDB implementation, many of the concepts presented apply to other database systems and storage engines. Armed with this knowledge, you will be better able to choose the appropriate storage engine for your application, select appropriate transaction modes, and understand how to diagnose performance problems that are a result of concurrency bottlenecks.

Heikki Tuuri

Innobase / Oracle Corp.

Heikki Tuuri is the creator of the InnoDB transactional storage engine in MySQL. He founded Innobase Oy in 1995 and is the CEO of the company. Prior to founding Innobase Oy, Tuuri worked at the University of Helsinki, from which he also received a Ph.D, degree in mathematical logic in 1990.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL 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@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.