4 messages in com.mysql.lists.clusterRe: ndb unique index performance issues
FromSent OnAttachments
Yong Lee29 Jun 2006 16:01 
Benton, Kevin29 Jun 2006 16:42 
Simon Garner29 Jun 2006 17:40 
Stewart Smith29 Jun 2006 22:29 
Subject:Re: ndb unique index performance issues
From:Stewart Smith (stew@mysql.com)
Date:06/29/2006 10:29:37 PM
List:com.mysql.lists.cluster

On Fri, 2006-06-30 at 12:40 +1200, Simon Garner wrote:

MySQL Cluster has problems with often choosing incorrect indexes for queries. It's something to do with not having accurate index statistics, as I understand it.

Yeap. it should be better in 5.0 though

also look at ndb_use_exact_count option.

-- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: 66@sip.us.mysql.com Mobile: +61 4 3 8844 332

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html