MySQL Forums
Forum List  »  InnoDB

Re: MySQL Partitioning
Posted by: Rick James
Date: July 07, 2014 07:30AM

> I want to use MySQL partitioning.In the document

Why? I ask because partitioning does not automatically provide any benefits. There are a limited number of use cases where PARTITION is useful. A Rule of Thumb: Don't PARTITION unless the table will have more than a million rows.

> i can find how to do partitioning i.e Range,List,Hash partitioning etc..

RANGE is useful for the use cases; the rest are not.

> However i can't find how to configure multiple data Node in the partitioning. is partitioning is only for single Machine ?

Multiple machines is called "sharding". PARTITION is limited to one machine. "Fabric" can shard.

Options: ReplyQuote


Subject
Views
Written By
Posted
1179
July 05, 2014 11:21PM
Re: MySQL Partitioning
716
July 07, 2014 07:30AM


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.