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_mgmd(MGM)] 2 node(s) id=1 @10.0.0.3 (Version: 5.0.22) id=2 @10.0.0.4 (Version: 5.0.22) [mysqld(API)] 18 node(s) id=5 @10.0.0.5 (Version: 5.0.22) id=6 @10.0.0.8 (Version: 5.0.22) id=7 @10.0.0.2 (Version: 5.0.22) id=8 @10.0.0.1 (Version: 5.0.22) id=9 @10.0.0.9 (Version: 5.0.22) id=10 @10.0.0.10 (Version: 5.0.22) id=11 @10.0.0.11 (Version: 5.0.22) id=12 @10.0.0.6 (Version: 5.0.22) id=13 @10.0.0.3 (Version: 5.0.22) id=14 @10.0.0.7 (Version: 5.0.22) id=15 @10.0.0.12 (Version: 5.0.22) id=16 @10.0.0.13 (Version: 5.0.22) id=17 (not connected, accepting connect from any host) id=18 @10.0.0.254 (Version: 5.0.22) id=19 @10.0.0.4 (Version: 5.0.22) id=20 (not connected, accepting connect from any host) id=21 (not connected, accepting connect from any host) id=22 (not connected, accepting connect from any host) 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! -- Xueron Nee <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
