Re: MySQL: FLUSH TABLES WITH READ LOCK?
Hi there,
yes, it is actually working.
Meanwhile I have scrapped my ksh script and ported the entire thing to perl and DBI.
Works fine for me now.
The trick is to keep the MySQL session from which you issued the "FLUSH TABLES WITH READ LOCK" open all the time.
As soon as you close this session your "READ LOCK" vanishes.
You can safely assume that there are no more "dirty pages" as soon as the "FLUSH TABLES..." command returns.
Kind regards
Lutz
Subject
Views
Written By
Posted
22926
August 16, 2005 05:34AM
8741
September 08, 2005 03:55AM
Re: MySQL: FLUSH TABLES WITH READ LOCK?
8545
September 23, 2005 04:41AM
6758
September 30, 2005 02:16AM
6240
August 10, 2008 06:50AM
4560
August 26, 2008 01:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.