List:Cluster« Previous MessageNext Message »
From:Andrew Morgan Date:July 19 2011 10:09am
Subject:RE: mysql cluster partition
View as plain text  
The contents of the file system is going deeper into the implementation than
I’m qualified to comment on but note that the DBDICT block is for the data
dictionary/meta data rather than the actual data.



Regards, Andrew.



From: 牛兆捷 [mailto:nzjemail@stripped]
Sent: 19 July 2011 11:00
To: Andrew Morgan
Subject: Re: mysql cluster partition



In my data node,I find these info



36K     ndb_4_fs/D2/DBDICT/T4

36K     ndb_4_fs/D2/DBDICT/T9

36K     ndb_4_fs/D2/DBDICT/T3

36K     ndb_4_fs/D2/DBDICT/T5

36K     ndb_4_fs/D2/DBDICT/T7

36K     ndb_4_fs/D2/DBDICT/T1

36K     ndb_4_fs/D2/DBDICT/T10

36K     ndb_4_fs/D2/DBDICT/T8

36K     ndb_4_fs/D2/DBDICT/T6

36K     ndb_4_fs/D2/DBDICT/T2

36K     ndb_4_fs/D2/DBDICT/T11



What does the T* stand for?

Does it means the partitions?But I only set 8 partitions.

How does the partitions of table of ndb engine stored in disk



2011/7/19 Andrew Morgan <andrew.morgan@stripped>

Here’s a good place to start for information on how MySQL Cluster
partitions its tables….
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-nodes-groups.html



In general, you don’t need to specify the number of partitions, MySQL
Cluster will automatically create the correct number based on the number of
data nodes you have.



Regards, Andrew.






-------- Original Message --------


Subject:

mysql cluster partition


Date:

Tue, 19 Jul 2011 11:56:37 +0800


From:

牛兆捷  <mailto:nzjemail@stripped> <nzjemail@stripped>


To:

cluster@stripped



I know the default partition of mysql cluster is by primary key,but where
can I know the detail of the partition procedure?

Fox example I have 8 data node ,I set the number of partition number as 8
too,so will it partitions the whole data to 8 parts
and distributing them on 8 node uniformly?

If I don't set the partitions number explicitly,what is the default number
of the partitions number?

Thanks





Thread
mysql cluster partition牛兆捷19 Jul
RE: mysql cluster partitionAndrew Morgan19 Jul
  • Re: mysql cluster partitionJohan Andersson19 Jul
RE: mysql cluster partitionAndrew Morgan19 Jul
  • RE: mysql cluster partitionStewart Smith19 Jul