Re: Database Rollback?
I can imagine the loss of some minutes when the operating system stops without clean shutdown. But a whole day is just unbelievable. Your system may do weird things on reboot.
What you say about invoices doesn't make much sense to me. Please explain your application in terms of table layout (SHOW CREATE TABLE) and SQL statements.
MyISAM cannot do rollback. Every change is immediately written to the data file. But this file is not flushed to disk immediately. The operating system flushes it on its own discretion. This is the reason why data can be lost if the operating system stops without flushing its file system cache. Usually the OS flushes in one to five minute intervals.
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
8215
April 04, 2006 04:45PM
2728
April 05, 2006 12:14PM
2362
April 05, 2006 03:55PM
Re: Database Rollback?
2254
April 05, 2006 12:22PM
2307
April 05, 2006 04:02PM
2051
April 06, 2006 01:53AM
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.