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?
Subject
Views
Written By
Posted
4691
December 23, 2013 08:20AM
1745
December 24, 2013 11:01AM
1499
December 24, 2013 02:48PM
1507
December 25, 2013 04:57PM
1405
December 27, 2013 03:06AM
1416
December 27, 2013 03:53AM
1268
December 27, 2013 04:53AM
1442
December 28, 2013 01:12PM
1215
December 29, 2013 04:59AM
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.