flush table with read lock

2004-07-26 Thread MaFai
Dear, [EMAIL PROTECTED], Does flush table with read lock timeout? E.g: 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

Re: flush table with read lock

2004-07-26 Thread Paul DuBois
At 9:52 +0800 7/27/04, MaFai wrote: Dear, [EMAIL PROTECTED], 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

Re: Re: flush table with read lock

2004-07-26 Thread MaFai
Dear Paul DuBois: Good,it can use make a hot backup by this lock. or make a snapshot for replication. Thx At 2004-07-27, 10:13:43 you wrote: At 9:52 +0800 7/27/04, MaFai wrote: Dear, [EMAIL PROTECTED], Does flush table with read lock timeout? No, but the lock