|
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 |
||
|
1887.3.2
by Brian Aker
Extended documentation. |
6 |
FLUSH |
7 |
flush_option [, flush_option] ... |
|
8 |
||
9 |
flush_option: |
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
10 |
|
11 |
* TABLES table_name [, table_name]
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
12 |
|
13 |
(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 |
14 |
|
15 |
* TABLES WITH READ LOCK
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
16 |
|
17 |
(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 |
18 |
|
19 |
* LOGS
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
20 |
|
21 |
(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 |
22 |
|
23 |
* STATUS
|
|
|
1994.4.20
by Marisa Plumb
fixed build warnings |
24 |
|
25 |
(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. |
26 |
|
|
1994.4.6
by Marisa Plumb
flush.rst formatting |
27 |
To release a FLUSH TABLES WITH READ LOCK, you must issue an UNLOCK TABLES. |