Bill Easton wrote:
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.... 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.)
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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
