MySQL Forums
Forum List  »  Partitioning

User requirements for MySQL Partitioning
Posted by: jey Razack
Date: May 25, 2005 11:11AM

Listed below are the required features to manage >1TB VLDBs:

- Global index on the primary table (across partitions)
- Local indexes on each partitions.
- Select fld1,... from <PrimaryTable>.<PartitionName> WHERE ....
- sqldump : dump entire table or selected partitions
- import entire table or selected partitions.
- Move partition from one tablespace to another/new.
- Merge,split , rename,truncate and drop partitions. Also set status to active or inactive.
- Option to load any partition to cache (heap storage engine may not help)
- Able to create view on a set of selected partitions.
- Optimization hints for Index usage and other select / join operations.
- Don't allow to drop all the partitions. Atleast the table must have one active partition.
- Row counts are cached for each partitions and for the entire table so that
the select count(*) from <table>.<partition> will display the count faster.

Regards..
Jey Razack

Options: ReplyQuote


Subject
Views
Written By
Posted
User requirements for MySQL Partitioning
3841
May 25, 2005 11:11AM


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.