Innodb Architecture and Performance Optimization
October 24th, 09:00 AM
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
- Disk IO
- Multi Versioning
- Row Locking
- Page flushing and Replacement
- Insert Buffering
- Adaptive Hash Index
- BLOB Storage
- 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.
Founder and CEO, Percona
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.