Innodb and XtraDB Architecture and Performance Optimization

This "classical" Innodb and XtraDB architecture tutorial was updated to reflect changes and new features in latest versions of MySQL and Percona Server. It will 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 latest MySQL and Percona Server releases in regards to Innodb storage engine as part of this presentation.

Track: 
Database Administration
Experience level: 
Intermediate

Schedule info

Time slot: 
10 April 09:30 - 12:30
Room: 
Ballroom G

Schedule Info

10 April 09:30 - 12:30 @
Ballroom G

Speakers

Peter Zaitsev's picture
CEO, Percona Inc

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.

Slides




Sponsored By