Heikki Tuuri wrote:

Ji-Haw,

if the OS crashes do not corrupt files, then InnoDB tables would survive an OS crash without a problem.

Thanks for the reply Heikki. Let me rephrase my problem: the data remains intact, but I suspect the indexes are corrupted. Basically I have to run myisamcheck and mysqlcheck to get my tables operational again. No data loss though.

Logan (thanks Logan) suggested a periodic flush call. I am wondering if auto flushing is available?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to