Tutorial
Innodb Architecture and Performance Optimization

Sponsors
Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Booking.com Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 24th, 09:00 AM
Ludgate Suite

Abstract

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.

Slides

Innodb Architecture and Performance Optimization

Download Slides

Speaker

Peter Zaitsev

Peter Zaitsev

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.

 

]]> ]]>