MySQL Forums
Forum List  »  InnoDB

Re: Heavy data lost in InnoDB after a bad-shutdown
Posted by: Rick James
Date: December 30, 2013 01:55AM

> I can not find innodb_fast_shutdown in my.ini file

SHOW VARIABLES LIKE 'innodb%';

> I can find ALL lost records from 14 to 21 december

So the problem is with the reload? Or maybe somehow undoing after the reload? Puzzling.

> The log deletion was done just to test how old was the last checkpoint.

If you load the dump from the 21st, but with the logs intact, what happens? Are the rows gone or not?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Heavy data lost in InnoDB after a bad-shutdown
1178
December 30, 2013 01:55AM


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.