MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Can I store the .frm and .ibd files at a different location
Posted by: Rick James
Date: October 12, 2013 01:21PM

Windows? Linux? (different approaches for them)

It is possible to move the whole table to some other place, but it needs to be done carefully. (Sorry, I don't have the details.)

You cannot split the index from the data.

Please describe the rest of the situation. Moving indexes to NVRAM is a rather extreme case. InnoDB does a good job of caching the index blocks in RAM in the "buffer pool". innodb_buffer_pool_size should be set to about 70% of RAM to give it lots of room.

If you had the indexes in NVRAM, it would copying blocks between the buffer_pool and NVRAM. (The same applies if you use a "ram disk".)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Can I store the .frm and .ibd files at a different location
1958
kanishka keshav
October 11, 2013 09:22AM
Re: Can I store the .frm and .ibd files at a different location
1119
Rick James
October 12, 2013 01:21PM
Re: Can I store the .frm and .ibd files at a different location
1294
kanishka keshav
October 14, 2013 02:21AM
Re: Can I store the .frm and .ibd files at a different location
812
Rick James
October 14, 2013 10:26PM


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.