From: MARK CALLAGHAN Date: July 8 2009 4:48am Subject: Re: Condition Pushdown for ha_partition List-Archive: http://lists.mysql.com/internals/37113 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Tue, Jul 7, 2009 at 8:58 PM, kentoku wrote: > Hi there, > > I'm pleased to announce the release of Condition Pushdown for > ha_partition in Launchpad. > http://launchpad.net/partitionconditionpushdownformysql > > This release is a patch file for MySQL's table partitioning feature. > (ndb is excluded) > This patch file works to add methods("cond_push" and "cond_pop") to > ha_partition. As a result, every storage engine's table that use table > partitioning can get condition-pushdown through ha_partition. > > There was no problem because only ndb supported > engine-condition-pushdown up to now. > This patch was needed because the Spider storage engine supported > engine-condition-pushdown recently. Great work. But is this safe to use with Innodb given http://bugs.mysql.com/bug.php?id=45029 which recommends that engine_condition_pushdown=off be used? -- Mark Callaghan mdcallag@stripped