MySQL 6.0 Subquery optimizations are published.

MySQL 6.0 Subquery optimizations are published.

PREVIOUS POST
NEXT POST

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.

PREVIOUS POST
NEXT POST

Share this post

Comments (4)

  • Ken Reply

    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?

    February 6, 2008 at 12:00 am
  • marcis Reply

    Naiss.. Waiting for mysql 6 🙂

    February 6, 2008 at 7:34 am
  • DBNews 2007 #5 | PettiNix Reply

    […] degli sviluppi dei DBM sarà un’interessante lettura quella dell’articolo dedicato alle ottimizzazioni delle SubQuery in MySQL 6.0. Per i tecnici che utilizzano InnoDB invece tre tutorial interessanti: introduzione ad InnoDB, […]

    February 10, 2008 at 8:25 am
  • Propiedad Privada » Blog Archive » Miscelánea de enlaces sobre Bases de datos Reply

    […] Optimizaciones de subqueries en MySQL 6, en MySQL 6.0 Subquery optimizations are published […]

    February 27, 2008 at 5:31 am

Leave a Reply