List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:February 10 2006 10:24am
Subject:RE: Surviving MySQL crash
View as plain text  
That sounds an even better idea!

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 6:57 PM
To: Dan Nelson
Cc: David Logan; Heikki Tuuri; mysql@stripped; Logan, David (SST
- Adelaide)
Subject: Re: Surviving MySQL crash


>>15 * * * * /usr/local/mysql/bin/mysql -u root -pxxxxxx -e 'FLUSH
TABLES'
>>
>>This would run a FLUSH TABLES once every hour at 15 minutes past. If
you 
>>are using Windows, sorry I'm not sure how to do it there.
>>    
>>
>
>Easier to just set flush_time=900 in my.cnf :)
>  
>
Thanks guys. Will give it a shot.

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