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
On
k I/O capacity or add some caching 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 do
efore 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: IN
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) unti
