The FLUSH Statement

• The FLUSH statement clears or reloads various internal caches used by MySQL.
  • To execute FLUSH, one must have the RELOAD privilege.

• FLUSH TABLES WITH READ LOCK acquires a global read lock and not table locks.
  • It is not subject to the same behavior as LOCK TABLES and UNLOCK TABLES with respect to table locking.

• FLUSH TABLES WITH READ LOCK is not logged in any case because it would cause problems if replicated to a slave.

Can I use mysqldump for backup?

---

---

© 2007 John Michael Pierobon

Notes