MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 27 2004 2:13am
Subject:Re: flush table with read lock
View as plain text  
At 9:52 +0800 7/27/04, MaFai wrote:
>Dear, mysql@stripped,
>Does "flush table with read lock " timeout?

No, but the lock will be released if the client connection drops.
There is an inactivity timeout on client connections, so after
that timeout expires, the server will close the connection.  As
a side effect the lock will be released.

>After we excute "flush table with read lock ",
>All of the table in all of the database can't be updated or delete.
>But if we doesn't execute 'unlock tables',does it release the lock 
>due to time out?
>Any idea appreciated.
>Best regards.
>                 MaFai
>                 zh-ma@stripped
>                 2004-07-27

Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
flush table with read lockMaFai27 Jul
  • Re: flush table with read lockPaul DuBois27 Jul