MySQL Forums
Forum List  »  InnoDB

Data Directory Questions
Posted by: duke hound
Date: July 02, 2008 08:39PM

I have several questions about data directories

1) Can you use the DATA DIRECTORY clauses on the table level with the InnoDB engine?
2) Can you use the DATA DIRECTORY clauses on the partition level with the InnoDB engine?
3) Can you use the DATA DIRECTORY clause on the partition level without using the INDEX DIRECTORY clause?
4) How do you use the DATA DIRECTORY clause for partitions that use the key and hash functions?

The documentation was less than clear about these points.

I am going to need a 2 terrabyte partitioned table that we would like to be InnoDB, but if we cannot split the partitions up on to different disks is our only option to go with NDB, clusters? (but then aren't there draw backs to using clusters and partitions?...i suppose the need for partitions goes down once you cluster everything)

Thanks for the help,

Options: ReplyQuote


Subject
Views
Written By
Posted
Data Directory Questions
2021
July 02, 2008 08:39PM


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.