MySQL Forums
Forum List  »  InnoDB

index location for innodb engines tables
Posted by: Matthijs Zwart
Date: November 18, 2013 09:57AM

Hi,

with MyIsam it's possible to set a location for the indexes of a table. This can be beneficial in some cases, like storing the actual data on a raid 01 with normal HD's and the index on a SSD.
Create table looks something like this (where mysql has the data on the D drive):

CREATE TABLE IF NOT EXISTS `mydb`.`table1` (
`id` INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`))
ENGINE = MyISAM
INDEX DIRECTORY = 'c:\MySQLIndices';

Is there any way I can do something like this with inno db tables? Or benefit in any other way from the SSD speed, other than moving the entire data collection to the SSD ('cause that's not what I want).
Kind regards,

Matthijs

Options: ReplyQuote


Subject
Views
Written By
Posted
index location for innodb engines tables
1460
November 18, 2013 09:57AM


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.