MySQL Forums
Forum List  »  Partitioning

Table as well as Physical Partitioning
Posted by: Michael Gargiullo
Date: September 21, 2006 08:39AM

Hey all,

I'm working on a project to convert an existing data storage system to MySQL from Oracle. Currently in Oracle, we have 3hour partitions setup, each partition on it's own physical disk.

Currently, each night we create the table space and partitions 48 hours in advance. The table receives an insane amount of data (Currently inserting 770M/day moving towards 2B/day) while maintaining indexes, querying,etc.

Can I specify physical paths per partition/index? We would like to partition out the indexes from the data as well. These data rates have already pushed us away from SCSI to SATA, just for the throughput to disk.

Is any of this possible in MySQL?

Options: ReplyQuote

Written By
Table as well as Physical Partitioning
September 21, 2006 08:39AM

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.