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 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.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
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 MySQL Conference newsletter.
View a complete list of MySQL contacts.