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]