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

[Tobia Bea]

The crash was caused by power failure.

I did not change any settings, all settings was set to default by the windows installer of MySQL SERVER 5.6.13 with a "server only" installation and configured with config type option as "server machine".
Also this "innodb-autoextend-increment" option was surely not changed (I'm reading about it now for the first time), so I think this is set to default.

Regarding transaction, all are managed by Hibernate and JDBC connector. And moreover, I think the previous normal shutdown of mysql whould have to close all transactions... it is unbelivable a 6day transaction between many server restart, am I right?
This application is a local web application where the computer is turned on in the morning and shut down in the evening, every day, so mysql has at least one restart per day).

I would be really grateful for the help, as you can understand this is a big trouble. Thank you