April 2014

MySQL 5.7 just rocks! ;-)

A next MySQL 5.7 milestone release is available an it just rocks! ;-)

few benchmark results to see where we're today comparing:

• MySQL 5.7 / 5.6 / 5.5
• Percona Server 5.6 / 5.5
• MariaDB 10 / 5.5

for all engines the latest available versions were used; the data set is fitting memory size, so the main focus is on the internal contentions here: already fixed for some engines, or still remained for another ones ;-)

Sysbench OLTP_RO 8-tables :


Sysbench OLTP_RO Point-Selects 8-tables :


Sysbench OLTP_RW 8-tables :


All details about these benchmark results and others (IO-bound OLTP_RW, Uniform & Pareto, DBT2, LinkBench) - I'll present during my talk tomorrow at PerconaLive 2014. I will also cover: all internals about InnoDB flushing design and how we're making it yet more improved it in 5.7, fixed and pending issues we have for today, the impact of InnoDB purge, filesystem and flash storage choices on IO-heavy workloads, and several still pending unexplained mysteries around.. - prepare your brain for some storming ;-)

If you're attending Percona Live, don't miss the following talks from MySQL Team :

• A keynote by Tomas Ulin this morning
• All New InnoDB stuff in MySQL 5.7 by Sunny Bains
• All MySQL 5.7 Replication news by Luis Soares
• All MySQL 5.7 Sharding with Fabric News by Mats Kindahl
• All about MySQL 5.7 Core Server Improvements by Morgan Tocker
• And awesome stuff around MySQL 5.7 Performance Schema by Mark Leith