the system down for a 4-hour tape backup... ;(
A Message original
A Sujet: possible problems with FLUSH TABLES WITH READ LOCK
A De: Antoine [EMAIL PROTECTED]
A Date: Mar, 26 Novembre 2002, 17:27
A A: [EMAIL PROTECTED]
A Hi,
A I am using FLUSH TABLES WITH READ LOCK to get consistent
Hello Victoria,
You need to do it with 2 sessions.
According MySQL manual:
If you are using a Veritas filesystem, you can do:
1. From a client (or Perl), execute: FLUSH TABLES WITH READ LOCK.
2. From another shell, execute: mount vxfs snapshot.
3. From the first client,
Sujet: possible problems with FLUSH TABLES WITH READ LOCK
De: Antoine [EMAIL PROTECTED]
Date: Mar, 26 Novembre 2002, 17:27
A: [EMAIL PROTECTED]
Hi,
I am using FLUSH TABLES WITH READ LOCK to get consistent
snapshots of my database without shutting it down.
The setup is :
- bi-P4 Xeon
Hi,
I am using FLUSH TABLES WITH READ LOCK to get consistent
snapshots of my database without shutting it down.
The setup is :
- bi-P4 Xeon with Redhat 7.3
- 2.4.19 kernel with properly patched LVM (compiled from source)
- MySQL server 4.0.4 (compiled from source)
- ext3 filesystem on a 44 GB