List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 12 1999 2:48am
Subject:FLUSH TABLES blocking problem
View as plain text  
>>>>> "web" == web  <web@stripped> writes:

>> Description:
web> The following (simplified from the real case) sequence causes FLUSH TABLES to take
> forever:

web> In thread 1:
web> LOCK TABLE a (READ|WRITE it doesn't matter)
web> FLUSH TABLES
web> isamchk a
web> FLUSH TABLES
web> UNLOCK TABLES

web> Simultaneously in thread 2:
web> SELECT * from a

web> mysqladmin proc output
web> | 250952 | web  | localhost |         | Query     | 100  | Flushing tables   |
> FLUSH TABLES
web> | 256010 | web  | localhost | echelon | Query     | 100  | Waiting for table |
> SELECT * FROM a

web> This is using the latest libc_r for FreeBSD.

Hi!

I think this is fixed in MySQL 3.22.27.  Could you try it?

Regards,
Monty
Thread
FLUSH TABLES blocking problemweb10 Oct
  • FLUSH TABLES blocking problemMichael Widenius12 Oct
RE: FLUSH TABLES blocking problemweb13 Oct