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 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. > > 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. > > > Best regards. > > MaFai > [EMAIL PROTECTED] > 2004-07-27 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] = = = = = = = = = = = = = = = = = = = = = = Best regards. MaFai [EMAIL PROTECTED] 2004-07-27
