Well, this problem occured to me first time. Yesterday, one of our mysql system server crashed and when it restarted last few inserts were completely rollbacked.
I am sure that they were proper inserts as we fetch results after inserts to print a PDF and PDF was generated properly. and system was crashed after 2-3 minutes of that INSERT operation.
System is PHP - MySQL based and we are using MyISAM as storage engine for our tables with autocommit ON
This is unique as earlier, after a system crash we normally had crashed tables but nothing like rollback operation. all the table are intact and operational after system crash.
Can anyone explain to me how is that possible if autocommit is ON. Thanks in advance