That sounds an even better idea!
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 6:57 PM
To: Dan Nelson
Cc: David Logan; Heikki Tuuri; [email protected]; 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
