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 all the changes from bin-log to the respective tables. Thanks you all in advance. regards anandkl