From: Date: July 3 2009 11:08pm
Subject: Re: Debugging a JOIN (custom storage engine)
List-Archive: http://lists.mysql.com/internals/37083
Message-Id: <4A4E734F.6050107@sun.com>
MIME-Version: 1.0
Content-Type: text/plain; CHARSET=US-ASCII; format=flowed
Content-Transfer-Encoding: 7BIT

MARK CALLAGHAN wrote:
> On Thu, Jul 2, 2009 at 11:54 PM, Jess Balint<Jess.Balint@stripped> wrote:
>> 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
> 
> But that bug has been closed, so all of these problems have been fixed right?

he he

> 
> With the exception of NDB, I don't understand the point of developing
> a storage-engine enhancement feature that doesn't work with InnoDB.

not that i'm a innodb expert...but given the benefits that has been shown...i find
it very likely that it will be fixed

maybe a new bug is a way forward (subject: MRR/BKA disabled for Innodb)
since this bug (apparently) was about tracking the problems...

/Jonas