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 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 > 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. Baron
