"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/flush.rst" (6 May 2012, 857 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:

As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.


The FLUSH statement clears or reloads different internal caches. One variant acquires a lock.

FLUSH flush_option [, flush_option] ...


(closes all specified tables, forces those tables in use to be closed, and flushes the query cache for the named tables)

(closes all open tables and locks all tables for all databases with a global read lock*)

(closes and reopens all log files--if binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file)

(adds the current thread's session status variable values to the global values and resets the session values to zero)

To release a FLUSH TABLES WITH READ LOCK, you must issue an UNLOCK TABLES.