On Thu, Dec 01, 2011 at 10:29:44PM +0400, Sergei Petrunia wrote:
To be continued... Continued:
== Optimizer debugging == We have discussed something like this in Athens and even before it. I've just implemented it, please take a look at http://kb.askmonty.org/en/mariadb-53-optimizer-debugging REQUEST: Can we get semi-join testing done with these settings: debug_optimizer_dupsweedout_penalized=ON optimizer_prune_level=0 REQUEST: I'm not exactly sure what to do with @@debug_optimizer_prefer_join_prefix, we both should think about how to use it (take a query, and try forcing all possible join orders?). At least, it should be easier to repeat the bugs now. BR Sergei -- Sergei Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog