Re: Heavy data lost in InnoDB after a bad-shutdown

[Tobia Bea]

I can not find innodb_fast_shutdown in my.ini file (mind I have the default "server" type default configuration), however it can be set by default. I don't have innodb_file_per_table option, so I think it is set by default to 0.

I can confirm that in all evening dumps made with mysqldump I can find ALL lost records from 14 to 21 december, in the 22nd december dump I found the record gap ... this is why I can not belive a transaction error, mysqlsump could read only committed records.

The log deletion was done just to test how old was the last checkpoint.
Don't you think it could be a checkpoint problem of inno logs? Mysqldump read from unflushed logs for 6 days, the power failure broke the log, innodb tried to restore logs but it fails, than db data back to last, 6 day old, checkpoint.



Edited 1 time(s). Last edit at 12/29/2013 05:02AM by Tobia Bea.