Foo Ji-Haw wrote:
Heikki Tuuri wrote:
Ji-Haw,
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?
Hi,
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.
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]