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….

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 --------


mysql cluster partition


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


牛兆捷  <mailto:nzjemail@stripped> <nzjemail@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?


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