it everything comes to a halt for
a good 30-40 seconds.
I can't make these long queries any faster. What can I do?
Thanks,
Nihal
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 7:09 PM
To: Nihal; [EMAIL PROTECTED]
Subject: Re: INNODB flush
on the disk controller.
Jeremy
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 7:09 PM
To: Nihal; [EMAIL PROTECTED]
Subject: Re: INNODB flush holdup
Hi,
I don't know what your previous problem was, but I don't think it
affects my answer
I am running FLUSH TABLES manually. I am doing it each hour to generate
a bin file, for incremental backups.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 10:05 AM
To: Nihal
Cc: [EMAIL PROTECTED]
Subject: Re: INNODB flush holdup
Hi,
I don't know what your previous problem was, but I don't think it
affects my answer. :-)
This isn't specific to InnoDB. Yes, when you FLUSH TABLES, all new
queries wait for that to complete (as indicated by Waiting for table
in PROCESSLIST). And the tables can't all be flushed (closed) until