MySQL 5.7: Performance & Scalability Benchmarks
3 April 1:00PM - 1:50PM @ Ballroom C
50 minutes conference
This session will be interesting for any person who cares about making MySQL fly! Any published MySQL Benchmark results always involving a lot of discussions around, and a lot of misunderstanding too.. Some benchmark workloads are helping to understand and fix MySQL Performance issues. Some, even running MySQL, not testing it at all ;-) So, the goal of this talk is to clarify all these points, including: - common test workloads - problematic workloads - MySQL 5.7 improvements & resolved issues - "best" practices, tuning and workarounds for unresolved problems - MySQL 5.7 / 5.6 -vs- MariaDB -vs- Percona Server benchmark results Of course, the topic is pretty wide for a one hour talk, but most of the critical points will be covered (main MySQL/InnoDB contentions, InnoDB flushing, Thread Pool, Performance Schema, etc.)
MySQL Performance Architect, Oracle
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.