index location for innodb engines tables
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
Subject
Views
Written By
Posted
index location for innodb engines tables
1460
November 18, 2013 09:57AM
1082
November 19, 2013 03:50PM
977
November 20, 2013 02:08AM
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.