This presentation cover the most important aspects of Innodb and XtraDB architecture as well as teach you to use them to archive best application performance and avoid bottlenecks. We will also look at Innodb settings corresponding to different architectural aspects. The following are the architecture parts to be covered: General Architecture • Storage and File Layout • Threads • Memory • Disk IO • Logging • Indexes • Multi Versioning • Row Locking • Latching • Page flushing and Replacement • Insert Buffering • Adaptive Hash Index • BLOB Storage • Recovery • Compression Features • Foreign Keys
We will also look into Performance Improvements done in XtraDB and MySQL Server 5.5 Innodb storage engine as part of this presentation.
Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
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 O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts