MySQL Forums
Forum List  »  Partitioning

Re: Table as well as Physical Partitioning
Posted by: Mikael Ronström
Date: September 21, 2006 03:22PM

Hi,

Michael Gargiullo Wrote:
-------------------------------------------------------
> 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.
>

If you are using MyISAM as storage engine this is possible.
Then you can use the DATA DIRECTORY parameter on a partition
to specify the path to the data file of the partition. With
INDEX DIRECTORY you can set the path to the index file of the
partition.


> Is any of this possible in MySQL?

All storage engines that make use of the DATA DIRECTORY and INDEX
DIRECTORY feature of partitions will make this possible.

Rgrds Mikael

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Table as well as Physical Partitioning
2050
September 21, 2006 03:22PM


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.