Re: Not able to see old data after moving innodb logfiles
Posted by:
Rick James
Date: October 20, 2014 04:56PM
> we tried to move innodb data and logfiles to another directory in order to isolate redo logs.
That is not as useful as one might think. Recommend putting everything back to where it was (if you still don't have a running system).
Multiple spinning drives -- it is better to use RAID striping than to manually position files between the drives.
Spinning drives plus SSDs -- spinning drives for logs.
Some details about where things are for InnoDB:
* ibdata -- required for proper running of InnoDB.
* iblog* -- needed during running, but it is ok to lose them after a clean shutdown; they will be rebuilt.
* data directory -- one subdirectory for each DATABASE. Those contains a few files for each TABLE.
* *.frm -- schema definition; lose them and it is painful to recover
* *.ibd -- where the data and indexes live if you have innodb_file_per_table=1 (else data+index is in ibdata1)
SHOW VARIABLES LIKE '%dir%'; -- shows several directory settings. Perhaps your problems stemmed from not changing the right subset.
Subject
Written By
Posted
Re: Not able to see old data after moving innodb logfiles
October 20, 2014 04:56PM
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.