MySQL Forums
Forum List  »  Partitioning

Re: help:about mysql cluster partition and parallel query
Posted by: Mikael Ronström
Date: January 17, 2007 05:23PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: help:about mysql cluster partition and parallel query
4406
January 17, 2007 05:23PM


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.