Re: index location for innodb engines tables
Posted by:
Rick James
Date: November 19, 2013 03:50PM
Not possible
InnoDB data _and_ indexes are together stored in .ibd file (or ibdata1 file).
Would you care to share your schema (SHOW CREATE TABLE) and some slow queries. We may be able to suggest improvements that don't require hardware changes. Or suggest other changes to make use of SSDs.
Subject
Views
Written By
Posted
1466
November 18, 2013 09:57AM
Re: index location for innodb engines tables
1086
November 19, 2013 03:50PM
981
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.