Comments on: More MySQL 6.0 news: next subquery optimizations WL pushed http://s.petrunia.net/blog/?p=50 Random observations made while working on MySQL / MariaDB query optimizer Sat, 04 Sep 2010 17:54:52 +0000 http://wordpress.org/?v=2.0.12-alpha by: performance issues with sub-queries in MYSQL 5 — Able Technology - Web Application Programmers and Consultants http://s.petrunia.net/blog/?p=50#comment-51827 Wed, 06 May 2009 19:49:37 +0000 http://s.petrunia.net/blog/?p=50#comment-51827 [...] The good news it is looks like it is fixed in version 6.0 - looking forward to it becoming a production release…. [...] […] The good news it is looks like it is fixed in version 6.0 - looking forward to it becoming a production release…. […]

]]> by: sergey http://s.petrunia.net/blog/?p=50#comment-40025 Sat, 03 Jan 2009 09:06:25 +0000 http://s.petrunia.net/blog/?p=50#comment-40025 Stefan, The failures weren't created by this push, they were already there, see BUG#31480, BUG#37893, BUG#38015, etc. I don't think it's time to disable these in 6.0 yet: first, 6.0 is still alpha and second, these are *edge* cases. Stefan,

The failures weren’t created by this push, they were already there, see BUG#31480, BUG#37893, BUG#38015, etc.

I don’t think it’s time to disable these in 6.0 yet: first, 6.0 is still alpha and second, these are *edge* cases.

]]> by: Stefan Kaltenbrunner http://s.petrunia.net/blog/?p=50#comment-39953 Fri, 02 Jan 2009 18:48:50 +0000 http://s.petrunia.net/blog/?p=50#comment-39953 Hmm - pushing a new feature to the tree that has serious known issues (ie generating wrong results for some queries seems bad) feels wrong. Why not take a more conservative approach and disable the optimization for all the cases it is known to be wrong before the code gets enabled? Hmm - pushing a new feature to the tree that has serious known issues (ie generating wrong results for some queries seems bad) feels wrong.
Why not take a more conservative approach and disable the optimization for all the cases it is known to be wrong before the code gets enabled?

]]>