InnoDB became the default storage engine in MySQL 5.5, and continues to improve in MySQL 5.6 (GA) and 5.7.
This talk describes how InnoDB works under the hood, and describes how various features such as MVCC, REDO/UNDO, double write buffer, change buffering and adaptive hash work.
There will be some discussion around configuration, but the main goal of this talk is to give attendees "x-ray vision" when debugging future problems.
Morgan rejoined the MySQL team at Oracle in 2013 as MySQL Community Manager, having previously worked for MySQL and Sun Microsystems. He blogs from tocker.ca, and especially likes the new features in MySQL that make operations life easier.
To provide the best experiences, the usage of cookies are necessary. Some are essential for the proper functioning of the site, while others help us better cater to your interests.