MySQL 5.7: Performance and Scalability Benchmark

Performance Optimization
4 November 3:10pm - 4:00pm @ Orchard 2

Duration: 
50 minutes conference
This session will be interesting for anyone who cares about making MySQL fly. Published MySQL benchmark results always engender a lot of discussions and a lot of misunderstandings. Some benchmark workloads are helping understand and fix MySQL performance issues, but others, some of which are running MySQL, are not testing it at all. So the goal of this session is to clarify all these points, including • Common test workloads • Problematic workloads • MySQL 5.7 improvements and resolved issues • Best practices, tuning, and workarounds for unresolved problems • MySQL 5.7/5.6 versus MariaDB versus Percona Server benchmark results The session also covers all the main MySQL/InnoDB contentions, InnoDB flushing, thread pools, the Performance Schema feature, and more.


Speakers

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.