Re: FLUSH TABLE LOCK READ

2007-05-30 Thread Baron Schwartz
ntaion say. And the changes will be in bin-log till the READ lock is held. regards anandkl On 5/30/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: Hi, Ananda Kumar wrote: > Hi All, > This question just for information sake. > If i do > > flush table lock read; I think you m

Re: FLUSH TABLE LOCK READ

2007-05-30 Thread Ananda Kumar
l, > This question just for information sake. > If i do > > flush table lock read; I think you mean FLUSH TABLES WITH READ LOCK? > Any changes happening on tables during this period, will it be viewable by > another user or will the user have to wait till the lock is released to see &

Re: FLUSH TABLE LOCK READ

2007-05-30 Thread Baron Schwartz
Hi, Ananda Kumar wrote: Hi All, This question just for information sake. If i do flush table lock read; I think you mean FLUSH TABLES WITH READ LOCK? Any changes happening on tables during this period, will it be viewable by another user or will the user have to wait till the lock is

FLUSH TABLE LOCK READ

2007-05-30 Thread Ananda Kumar
Hi All, This question just for information sake. If i do flush table lock read; Any changes happening on tables during this period, will it be viewable by another user or will the user have to wait till the lock is released to see the new changes And once the lock is released, does mysql apply