MySQL Forums
Forum List  »  Partitioning

Re: Partitioning in MySQL: Range Partitioning
Posted by: Mohamed OUADOU
Date: July 06, 2005 08:25AM


On many web site or e-commerce site, databases are used to store unstructured data and since MySQL is more used in such domain, round robin partitionning even if it is done via a hash table can be of a great help.

By the way some DBEngine use a hash table mapping to support round robin partitionning over multiple instance, and some others use an Instead Of trigger to populate tables which are parts of a global view !

As your memory come back, :-), yes this could help in maintenance operations by disabling a partition in order to restore it : "Writes than are possible on the other partitions and partial data read can be done only on the remaining partitions".

In range partitionning mode, a partition can be disabled, dropped or moved to a table and then if an insert occurs it will make an Exception in some cases. In other cases when enabling the disabled partition row movement occurs if it's enabled.

Rgrds Mohamed

Options: ReplyQuote

Written By
Re: Partitioning in MySQL: Range Partitioning
July 06, 2005 08:25AM

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.