Re: Power failure and innodb
Posted by:
Tobia Bea
Date: March 07, 2014 07:46AM
I know ib_logfile0 is vital, but I thought this can be the cause of a so heavy data loss... something like file corruption. The day before mysqldump could dump all data because it read from logs file, that data was unflushed for many days and the log corruption causes that heavy data loss...
Hibernate framework seems (by general log) to use begin...commit, but I do not think this is due to transaction problem, remember there were many server restart and many mysqldump backups from the rollback point and the disaster point. It is unbelivable there was a so big, unique and 3-days alive transaction.
If I can reproduce the error I will report it at bugs.mysql.com
Subject
Views
Written By
Posted
8169
January 27, 2014 09:45AM
2731
January 28, 2014 08:42AM
2775
February 24, 2014 06:21AM
2225
March 05, 2014 08:15AM
2081
March 05, 2014 10:42PM
Re: Power failure and innodb
1946
March 07, 2014 07:46AM
1446
February 02, 2015 09:33AM
1424
February 02, 2015 11:43AM
1529
February 03, 2015 05:09AM
1846
February 03, 2015 05:40AM
1481
February 03, 2015 07:04PM
1903
February 04, 2015 01:03PM
1166
June 04, 2015 07:35AM
2602
March 31, 2014 06:16AM
1462
March 18, 2015 11:12AM
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.