List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:February 10 2006 5:14am
Subject:RE: Surviving MySQL crash
View as plain text  
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: david.logan@stripped
****   _/  _/  _/  _/   ****  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:jhfoo-ml@stripped] 
Sent: Friday, 10 February 2006 3:45 PM
To: mysql@stripped
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

Thread
Surviving MySQL crashFoo Ji-Haw10 Feb
RE: Surviving MySQL crashSST - Adelaide)10 Feb
Re: Surviving MySQL crashHeikki Tuuri10 Feb
  • Re: Surviving MySQL crashFoo Ji-Haw10 Feb
    • Re: Surviving MySQL crashDavid Logan10 Feb
      • Re: Surviving MySQL crashDan Nelson10 Feb
        • Re: Surviving MySQL crashFoo Ji-Haw10 Feb
RE: Surviving MySQL crashSST - Adelaide)10 Feb