List:Internals« Previous MessageNext Message »
From:Jess Balint Date:July 3 2009 8: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 2009
  • Re: Debugging a JOIN (custom storage engine)Philip Stoev22 Jun 2009
    • Re: Debugging a JOIN (custom storage engine)Brian Aker22 Jun 2009
      • Re: Debugging a JOIN (custom storage engine)Jess Balint3 Jul 2009
        • Re: Debugging a JOIN (custom storage engine)MARK CALLAGHAN3 Jul 2009
          • Re: Debugging a JOIN (custom storage engine)Jonas Oreland3 Jul 2009
    • Re: Debugging a JOIN (custom storage engine)Slava Akhmechet22 Jun 2009
  • re: Debugging a JOIN (custom storage engine)Michael Widenius27 Jun 2009
  • Re: Debugging a JOIN (custom storage engine)Slava Akhmechet6 Jul 2009