~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/flush.rst

Committer: Lee Bieber
Date: 2011-01-08 01:57:02 UTC
mfrom: (1994.4.21 drizzle)
mto: This revision was merged to the branch mainline in revision 2063.
Revision ID: kalebral@gmail.com-20110108015702-d9mc4jwppb9vej94

Merge Marisa - latest doc updates, fix sphinx warnings

Show diffs side-by-side

added added

removed removed

docs/flush.rst

flush_option [, flush_option] ...

flush_option:

| TABLES table_name [, table_name] ...

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

| TABLES WITH READ LOCK

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

| LOGS

(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)

| STATUS

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

* TABLES table_name [, table_name]

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

* TABLES WITH READ LOCK

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

* LOGS

(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)

* STATUS

(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.

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

Older »