hello ,everyone
I want investigate two thing :
1. how mysql ndb cluster parallel full table scan and order index scan.
2. how mysql ndb cluster partition between nodegoups automatically using a hash function.
i have installed mysql ndb cluster 5.0.27.I installded ndbds two node groups . i want to study how mysql partition. i create a table and insert some records as follows:
CREATE TABLE s_pri_uni_idx (sno int ,sname char(50),PRIMARY KEY (sno),UNIQUE (sname))ENGINE=NDBCLUSTER;
insert into s_pri_uni_idx values(1,'lele');
insert into s_pri_uni_idx values(2,'fzb');
insert into s_pri_uni_idx values(3,'qinyun');
insert into s_pri_uni_idx values(4,'wangna');
insert into s_pri_uni_idx values(5,'NBA');
insert into s_pri_uni_idx values(6,'football');
When i debug the mysql cluster code,i find why mysql only insert records into one group and why mysqld olny send signals to one node group for querying data.
Did i install wrong msyql version ,shoud be above mysql-5.0?
or i debug the mysqld wrongly?
Can you give some advice!
thanks!
my email:
fzb0717@sohu.com
Edited 1 time(s). Last edit at 01/15/2007 08:59PM by fu zhibo.