Table as well as Physical Partitioning
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?
Subject
Views
Written By
Posted
Table as well as Physical Partitioning
3606
September 21, 2006 08:39AM
2150
September 21, 2006 03:22PM
2253
September 21, 2006 05:15PM
2309
September 22, 2006 11:54AM
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.