From: MARK CALLAGHAN Date: July 3 2009 2:48pm Subject: Re: Debugging a JOIN (custom storage engine) List-Archive: http://lists.mysql.com/internals/37078 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Thu, Jul 2, 2009 at 11:54 PM, Jess Balint 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? With the exception of NDB, I don't understand the point of developing a storage-engine enhancement feature that doesn't work with InnoDB. -- Mark Callaghan mdcallag@stripped