From: Dan Nelson
Date: February 10 2006 8:11am
Subject: Re: Surviving MySQL crash
List-Archive: http://lists.mysql.com/mysql/194747
Message-Id: <20060210081121.GC2090@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Feb 10), David Logan said:
> Foo Ji-Haw wrote:
> >Heikki Tuuri wrote:
> >>if the OS crashes do not corrupt files, then InnoDB tables would
> >>survive an OS crash without a problem.
> >
> >Thanks for the reply Heikki. Let me rephrase my problem: the data
> >remains intact, but I suspect the indexes are corrupted. Basically I
> >have to run myisamcheck and mysqlcheck to get my tables operational
> >again. No data loss though.
> >
> >Logan (thanks Logan) suggested a periodic flush call. I am wondering
> >if auto flushing is available?
> 
> You could set that up as a small cron job (Are you using unix/Linux?) 
> like so
> 
> 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 :)

-- 
	Dan Nelson
	dnelson@stripped