Hi,
fu zhibo Wrote:
-------------------------------------------------------
> 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?
>
Seems like you've debugged in the wrong since the probability of
doing as you see is very low. The data is more or less
randomly spread between nodes.
For logging to understand you can use a feature not documented but
available in debug-compiled code.
From the management client send the following commands:
ndb_mgm) all log block = ALL
ndb_mgm) all teston
Perform the tests you want to do.
ndb_mgm) all testoff
Check the message logs in the files
ndb_1_signal.log where 1 is node id.
Rgrds Mikael
> Can you give some advice!
>
> thanks!
>
> my email:
fzb0717@sohu.com