Re: Mysql cluster so slow...

2006-07-17 Thread Chris
Xueron Nee wrote: Hi all, There is a table contains about 60,000 rows. where select from this table with 'order by xxx' statement, it is tooo slow. but if i do it without 'order by xxx', it works fine. Is there any tips and suggestion for me? Thanks! Add an index to the 'xxx' column? That

Mysql cluster so slow...

2006-07-15 Thread Xueron Nee
Hi all, I am running a mysql cluster like this: ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration - [ndbd(NDB)] 2 node(s) id=3@10.0.0.1 (Version: 5.0.22, Nodegroup: 0, Master) id=4@10.0.0.2 (Version: 5.0.22, Nodegroup: 0) [ndb