; 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
backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: "Foo Ji-Haw" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, February 10, 2006 7:05 AM
Subject: Surviving MySQL crash
Hi all,
I have a MySQL server servng low-l
---
-Original Message-
From: Foo Ji-Haw [mailto:[EMAIL PROTECTED]
Sent: Friday, 10 February 2006 3:45 PM
To: mysql@lists.mysql.com
Subject: Surviving MySQL crash
Hi all,
I have a MySQL server servng low-load applications. Problem is, the
environment is sometimes unstable, leading the entire OS to
Hi all,
I have a MySQL server servng low-load applications. Problem is, the
environment is sometimes unstable, leading the entire OS to crash. I
notice that even in low-load situations the MySQL tables can be
corrupted during crashes.
My question is: is there a way for MySQL to flush when id
