; Heikki Tuuri; mysql@lists.mysql.com; Logan, David (SST
- Adelaide)
Subject: Re: Surviving MySQL crash
>>15 * * * * /usr/local/mysql/bin/mysql -u root -pxx -e 'FLUSH
TABLES'
>>
>>This would run a FLUSH TABLES once every hour at 15 minutes past. If
you
>>are
15 * * * * /usr/local/mysql/bin/mysql -u root -pxx -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
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
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
h
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 myisamchec
Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would survive an
OS crash without a problem.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also back
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
*** _/