XtraDB 5.6: Key Performance Algorithms

New Features
4 April 12:50PM - 1:40PM @ Ballroom C

Experience level: 
Advanced
Duration: 
50 minutes conference
We will describe the inner workings of XtraDB 5.6 from the performance point of view. We will focus on the new-in-XtraDB algorithms developed by Percona for performance, supported by experimental data. We will also discuss our motivation for making these and not other changes. Thus, we will talk about the XtraDB priority locking framework, InnoDB 5.6 flushing changes and XtraDB flushing improvements, the high-concurrency improvements, the considerations of XtraDB 5.5 features ported forward and other topics. We will show and discuss performance results for each feature. The talk will be technical with InnoDB algorithms discussed at a pseudocode level. The target audience for the talk would be InnoDB and performance engineers, and DBAs willing to get insight into advanced InnoDB tuning, especially in high-concurrency I/O-bound cases.


Speakers

Percona Server Lead, Percona
Biography: 
Laurynas joined Percona in 2011 as a member of the Percona Server, Percona XtraDB and Percona XtraBackup development group. Before coming to Percona, Laurynas was a PhD student at Aalborg University, in Denmark, where he did research on physical database indexes.
Performance Engineer, Percona
Biography: 
Alexey Stroganov is a Performance Engineer at Percona, where he works on  improvements and features  that makes Percona Server  even more flexible, faster and scalable.  Before joining Percona he worked on the performance testings/analysis of  MySQL server and it components at MySQL AB/Sun/Oracle for more than ten years.  During this time he was focused on performance evaluations, benchmarks,  analysis, profiling, various optimizations and tunings.

Slides