Re: MySQL Cluster performance question

On Thu, 2007-08-09 at 13:31 -0500, Brian Moon wrote:
> > mysql> SELECT DISTINCT gv_symbol FROM `past30_ndb_disk` FORCE INDEX
> > (`gvsymtime`) WHERE 1;
> > 90 rows in set (4 min 44.90 sec)
> >
> > mysql> SELECT DISTINCT gv_symbol FROM `past30_MYISAM` FORCE INDEX
> > (`gvsymtime`) WHERE 1;
> > 90 rows in set (1.54 sec)
>
> Can we see the create table on these? Frankly, the 1.54 seconds on the
> myisam seems low to me if a good key is used.

and EXPLAIN

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

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


application/pgp-signature attachment: This is a digitally signed message part