Hi,
If they are MyISAM tables, you can run a FLUSH TABLES statement at a
periodic interval. A good reference is here
http://dev.mysql.com/doc/refman/5.0/en/flush.html
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Foo Ji-Haw [mailto:[EMAIL PROTECTED]
Sent: Friday, 10 February 2006 3:45 PM
To: [email protected]
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]
