List:General Discussion« Previous MessageNext Message »
From:Michael T. Babcock Date:October 28 2002 3:18pm
Subject:Re: database corrupted after power switched off
View as plain text  
Bill Easton wrote:

>   ... which says "MyISAM table format is very reliable (all changes to a
>table is written before the SQL statements returns)"  Evidently, this is NOT true.
>(Perhaps, it used to be true for ISAM tables.  The documentation should be
>changed.)
>
You are misinterpreting the statement; it says that the database will be 
safe after the SQL command returns (all SQL commands active on the 
table, for that matter).  That is to say, if the power were turned off 
while any (update / etc.) SQL command was running, you could expect 
corruption.

Again, make sure you check how your OS deals with write caching and 
consider turning it off on the partition / disk you're using for DB storage.

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock


Thread
database corrupted after power switched offTom Thurnherr28 Oct
  • RE: database corrupted after power switched offEd Carp28 Oct
  • re: database corrupted after power switched offVictoria Reznichenko28 Oct
re: database corrupted after power switched offBill Easton28 Oct
  • Re: database corrupted after power switched offMichael T. Babcock28 Oct
  • Re: database corrupted after power switched offMark28 Oct
  • Re: database corrupted after power switched offBill Easton28 Oct
  • Re: database corrupted after power switched offMichael T. Babcock28 Oct
RE: database corrupted after power switched offJan Steinman28 Oct