Subquery optimizations in MySQL 6.0

I’ve finally found time to put together a couple of wiki pages describing what work we’re doing for subquery optimizations in MySQL 6.0:

  • The Subquery_Works page has an overview of what we’ve done so far, we’re doing now and our future plans.
  • The 6.0 Subquery Optimization Cheatsheet has a short, easy-to-read description of what has been released in MySQL 6.0.3. That should be enough if you just want to get the new version and see if your subquery is/can be faster now or not. If you want to know more details, the nearest occasion is my MySQL University session on February, 28.
  • I’ve done a quick preliminary assessment of the impact of new optimizations. The raw results and first conclusions are here on the 6.0 Subquery Optimization Benchmarks page. We will be doing more analysis and I intend to post more observations based on the already collected data, stay tuned.

That’s everything I have on subqueries so far, but as I’ve already mentioned more is on the way.

Posted in subqueries on February 5th, 2008 by spetrunia | |

2 Responses to ' Subquery optimizations in MySQL 6.0 '

Subscribe to comments with RSS or TrackBack to ' Subquery optimizations in MySQL 6.0 '.

  1. Guti said,

    on March 1st, 2008 at 4:12 pm

    Seems to be lots of speed improvements.
    Probably combining it with “Maria”, would get a very nice performance, as compared with 5.x.

  2. sergey said,

    on March 3rd, 2008 at 5:21 pm

    Well, at the moment subquery optimizations are not expected to have any interplay with Maria’s speedups that I am aware of.

    The good part is that they aren’t mutually exclusive either, so one can hope to get both Maria’s and subquery optimization improvements.

    IIRC the first release(s) of Maria are focused on recovery though.

Leave a reply

You must be logged in to post a comment.