List:Internals« Previous MessageNext Message »
From:Jess Balint Date:July 3 2009 6:54am
Subject:Re: Debugging a JOIN (custom storage engine)
View as plain text  
On Mon, Jun 22, 2009 at 07:03:27AM -0700, Brian Aker wrote:
> Hi!
>
> On Jun 22, 2009, at 3:27 AM, Philip Stoev wrote:
>
>> If so, please set optimizer_use_mrr=disable and try again.
>
> Is the conclusion that MRR is just completely broken right now?

I don't know about completely, but at least with InnoDB. See:
http://bugs.mysql.com/bug.php?id=45029

jess
Thread
Debugging a JOIN (custom storage engine)Slava Akhmechet22 Jun
  • Re: Debugging a JOIN (custom storage engine)Philip Stoev22 Jun
    • Re: Debugging a JOIN (custom storage engine)Brian Aker22 Jun
      • Re: Debugging a JOIN (custom storage engine)Jess Balint3 Jul
        • Re: Debugging a JOIN (custom storage engine)MARK CALLAGHAN3 Jul
          • Re: Debugging a JOIN (custom storage engine)Jonas Oreland3 Jul
    • Re: Debugging a JOIN (custom storage engine)Slava Akhmechet22 Jun
  • re: Debugging a JOIN (custom storage engine)Michael Widenius27 Jun
  • Re: Debugging a JOIN (custom storage engine)Slava Akhmechet6 Jul