Re: MySQL Cluster performance question

Thanks! I will give this a shot. We're also going to be adding two more data nodes in the next day or so, so hopefully performance gains will be considerable (<1 minute).

On 8/9/07, Bond Masuda <bond.masuda@jlbond.com> wrote:
> Not sure if this will help, but worth a try:
>
> In your /etc/my.cnf, add:
> [mysqld]
> ndb_force_send=1
> ndb_use_exact_count=0
> engine_condition_pushdown=1
>
> In your /var/lib/mysql-cluster/config.ini, add:
> [MYSQLD DEFAULT]
> BatchByteSize=1M
> BatchSize=992
>
> Generally speaking though, Cluster is slower than MyISAM in *many* cases. I
> don't think Cluster/ndbengine is meaningfully faster until you have several
> data nodes and happen to be in a situation that can utilize cluster's
> advantages.
>
> -Bond
>
> > -----Original Message-----
> > From: Al [mailto:broohaha@gmail.com]
> > Sent: Thursday, August 09, 2007 8:09 AM
> > To: cluster@lists.mysql.com
> > Subject: MySQL Cluster performance question
> >
> > Hello,
> >
> > Recently we decided to test out MySQL Cluster 5.1.19. We
> > have 1 mgm node, 2 data nodes, and 1 sql node with number of
> > replicas set to 2.
> > The servers are connected via Gigabit Ethernet.
> >
> > We have two tables past30_ndb_disk and past30_MYISAM that
> > contain the same data, but the former utilizes the cluster
> > on-disk while the latter is saved on the sql node as a MyISAM
> > table. The tables are 10,000,000 rows big taking up a little
> > over 1GB of space.
> >
> > We also have ndb_index_stat_enable = 0
> > And engine_condition_pushdown = On
> >
> > I ran the same query on both tables and got the following:
> >
> > 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)
> >
> >
> > I was not expecting a difference this drastic. Do you have
> > any tips on how to get a better response time?
> >
> > -Al
> >
> > --
> > MySQL Cluster Mailing List
> > For list archives: http://lists.mysql.com/cluster
> > To unsubscribe:
> > http://lists.mysql.com/cluster?unsub=bond.masuda@jlbond.com
> >
> >
>
>

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com