MySQL 5.6: Performance Benchmarks, Tuning and “Best” Practices

New Features
24 April 2:00pm - 2:50pm @ Ballroom A

This session will be interesting for any person who cares about making MySQL fly! Many of recently published MySQL 5.6 benchmark results involved a lot of discussions around, and a lot of misunderstanding too.. So, the goal of this talk is to clarify all these points, including:

  • common test workloads
  • problematic workloads
  • MySQL 5.6 improvements & resolved issues
  • common “best” practices and “base” tuning
  • adapted and advanced tuning / solutions
  • MySQL 5.6 vs 5.5 vs MariaDB benchmark results
  • better tuning and performance analyzing with MySQL 5.6 to run your production workloads faster

Of course, the topic is pretty wide for a one hour talk, but most of the critical points should be covered (main MySQL/InnoDB contentions, InnoDB flushing, Thread Pool, Performance Schema, etc.)

Let's explode myths and lies, and just focus on real results!

Speakers

Dimitri KRAVTCHUK
MySQL Performance Architect, Oracle
Biography: 
Over 20 years in the IT industry, focused mainly on databases and systems performance, with the past several years working full time on MySQL Performance at Oracle. Previously 15 years at the Sun Benchmark Center in Paris (now Oracle, currently OSC) working on customer's workloads performance and scalability optimizations, including various tender competitions. Previously at the Informix Benchmark Team in France. Author of the dim_STAT Performance Monitoring & Analyzing tool, and actively publishing MySQL Performance related articles at http://dimitrik.free.fr/blog.

Slides