MySQL Forums
Forum List  »  Partitioning

help:about mysql cluster partition and parallel query
Posted by: fu zhibo
Date: January 15, 2007 08:44PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
help:about mysql cluster partition and parallel query
8515
January 15, 2007 08:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.