MySQL Forums
Forum List  »  Partitioning

Re: help:about mysql cluster partition and parallel query
Posted by: fu zhibo
Date: January 23, 2007 08:50PM

hello,Mikael and every one
After installing Mysql NDB cluster 5.0.27 in RHEL3.0, We configurate two node groups(no replication among a node group).

I have some questions as follows:

1.It inserts data to two node group randomly? Does it scan all node groups or nodes simultaneously in full table scan and order index scan when executing a query?

2.How does mysql cluster know to fetch a row from which node when using parimary index?record node id in parimary index file? and Where is parimary index file stored?
such as a query:select * from s_pri_uni_idx where sno=2;

thanks!
my name:zhibo.fu

You can reply to email:fzb0717@sohu.com



Edited 1 time(s). Last edit at 01/23/2007 08:56PM by fu zhibo.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: help:about mysql cluster partition and parallel query
3864
January 23, 2007 08:50PM


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.