Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would survive an
OS crash without a problem.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
----- Original Message -----
From: "Foo Ji-Haw" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, February 10, 2006 7:05 AM
Subject: Surviving MySQL crash
Hi all,
I have a MySQL server servng low-load applications. Problem is, the
environment is sometimes unstable, leading the entire OS to crash. I
notice that even in low-load situations the MySQL tables can be
corrupted during crashes.
My question is: is there a way for MySQL to flush when idle for x
minutes, or some other way to avoid MySQL crashing (other than moving it
out of the environment)?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]