From: Johan Andersson
Date: July 19 2011 9:59am
Subject: Re: mysql cluster partition
List-Archive: http://lists.mysql.com/cluster/8091
Message-Id: <4E255580.4060400@severalnines.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------080607070803040404020305"

--------------080607070803040404020305
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

Hi,

You can also run:
ndb_desc -p -d <database_name> <tablename>
to printout how the partitions are laid out and how many records you
have in each partition.

Best regards,
Johan
web: www.severalnines.com/config <http://www.severalnines.com/config>
twitter: twitter.com/severalnines <http://twitter.com/severalnines>
skypeid: johan-at-mysql


On 2011-07-19 11.42, Andrew Morgan wrote:
> 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
>  
>


--------------080607070803040404020305--