|
1887.3.2
by Brian Aker
Extended documentation. |
1 |
FLUSH
|
2 |
=====
|
|
3 |
||
|
1994.4.3
by Marisa Plumb
few updates and modifications to admin commands |
4 |
The FLUSH statement clears or reloads different internal caches. One variant acquires a lock. |
5 |
||
|
2194.5.3
by Andrew Hutchings
Markup fixes |
6 |
.. code-block:: mysql |
7 |
||
8 |
FLUSH flush_option [, flush_option] ... |
|
9 |
||
10 |
flush_option
|
|
11 |
------------
|
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
12 |
|
13 |
* TABLES table_name [, table_name]
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
14 |
|
15 |
(closes all specified tables, forces those tables in use to be closed, and flushes the query cache for the named tables) |
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
16 |
|
17 |
* TABLES WITH READ LOCK
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
18 |
|
19 |
(closes all open tables and locks all tables for all databases with a global read lock*) |
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
20 |
|
21 |
* LOGS
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
22 |
|
23 |
(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) |
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
24 |
|
25 |
* STATUS
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
26 |
|
27 |
(adds the current thread's session status variable values to the global values and resets the session values to zero) |
|
|
1887.3.2
by Brian Aker
Extended documentation. |
28 |
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
29 |
To release a FLUSH TABLES WITH READ LOCK, you must issue an UNLOCK TABLES. |