April 24, 2014

MySQL 6.0 Subquery optimizations are published.

Sergey Petrunia brought to my attention the work Optimizer Team has done in MySQL 6.0 related to SubQuery Optimization.

I am excited to see this information published honestly outlining the things which are fixed now and things which are still not handled well. According to the bug sampling done by Optimizer Team 68% of reported issues are fixed (significantly improved) by changes in MySQL 6.0 which is far from all the issues but still very good number.

If you had issues with subqueries in MySQL 4.1 or 5.0 and pulled away from using them I’d encourage you to try MySQL 6.0 and see if your issues are fixed or described in the documentation published. If not report the bug and let optimizer team to know how you’re suffering :)

In particular you can review Currently Working Optimizations, Work in Progress and Plans, Benchmarks and Test Results

Hopefully in the future we’ll see more MySQL teams being proactive with publishing results of their work and plans. I’m especially looking to see developers writing themselves rather than documentation team or marketing writing about new features as developers often able to go much more in depth and explain those boring details you can see omitted by professional writers.

About Peter Zaitsev

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.

Comments

  1. Ken says:

    Hi Peter!

    In the past couple years, the roadmap for MySQL (and in particular MySQL 6) seems to have changed quite a bit. The latest stable release, 5.5, doesn’t yet have the sweet subquery optimizations that were planned/developed for 6.

    Do you know what the status of this work is these days?

  2. marcis says:

    Naiss.. Waiting for mysql 6 :)

Speak Your Mind

*