MySQL: FLUSH TABLES WITH READ LOCK?
Hey there,
currently I am testing a small backup script(ksh) which is supposed to create snapshots
of my MySQL database file systems using the Linux LVM2 snapshot feature.
In order to make sure that there are no "dirty pages" during the snapshot allocation I am issuing an "FLUSH TABLES WITH READ LOCK" from a MySQL client running within a ksh co coprocess.
I have a problem determining whether there a still some "dirty pages" or not.
A "SHOW STATUS" delivers a bunch of server settings and status information...
...but which of these values correspond to "dirty pages"?
Only "Key_blocks_not_flushed"?
Or something else?
My setup:
Operating System: RedHat Enterprise Linux 4 for IA32 + latest patches.
MySQL Server Version: 4.1.10a-2 as delivered by RedHat
MySQL Storage Engine: MyISAM
I'd really appreciate any hints...
Kind regards
Lutz
Subject
Views
Written By
Posted
MySQL: FLUSH TABLES WITH READ LOCK?
22925
August 16, 2005 05:34AM
8741
September 08, 2005 03:55AM
8545
September 23, 2005 04:41AM
6758
September 30, 2005 02:16AM
6239
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.