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.
On 5/30/07, Baron Schwartz <baron@stripped> wrote:
> 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
> > another user or will the user have to wait till the lock is released to
> > the new changes
> > And once the lock is released, does mysql apply all the changes from
> > bin-log
> > to the respective tables.
> The tables are locked. There will be no changes while they are locked.
> I don't think I really understand your question.