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 released to see
> the new changes
> And once the lock is released, does mysql apply all the changes from
> 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.