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

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 conne

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 loc