Hi Ananda,
I think you are confused about locks and the binlog both.
Locks lock tables. This disallows changes. READ locks prevent changes, but do
not block anyone from READING from the tables, and if I recall correctly, also
allow other people to get READ locks at the same time. WRITE lock
Hi Baron,
Its only a read lock, so changes on these table should be allowed, that is
what the documentaion 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 questi
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 releas
