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" <jhfoo-ml@stripped>
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/mysql?unsub=1
>
