Other Administrative Statements
1209
• If the thread is in the table lock handler (state:
Locked
), the table lock is quickly aborted.
• If the thread is waiting for free disk space in a write call, the write is aborted with a “disk full” error
message.
•
Warning
Killing a
REPAIR TABLE
or
OPTIMIZE TABLE
operation on a
MyISAM
table
results in a table that is corrupted and unusable. Any reads or writes to such a
table fail until you optimize or repair it again (without interruption).
13.7.6.4.
LOAD INDEX INTO CACHE
Syntax
LOAD INDEX INTO CACHE
tbl_index_list
[,
tbl_index_list
] ...
tbl_index_list
:
tbl_name
[[INDEX|KEY] (
index_name
[,
index_name
] ...)]
[IGNORE LEAVES]
The
LOAD INDEX INTO CACHE
statement preloads a table index into the key cache to which it has
been assigned by an explicit
CACHE INDEX
statement, or into the default key cache otherwise.
LOAD
INDEX INTO CACHE
is used only for
MyISAM
tables.
The
IGNORE LEAVES
modifier causes only blocks for the nonleaf nodes of the index to be preloaded.
The following statement preloads nodes (index blocks) of indexes for the tables
t1
and
t2
:
mysql>
LOAD INDEX INTO CACHE t1, t2 IGNORE LEAVES;
+---------+--------------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------+--------------+----------+----------+
| test.t1 | preload_keys | status | OK |
| test.t2 | preload_keys | status | OK |
+---------+--------------+----------+----------+
This statement preloads all index blocks from
t1
. It preloads only blocks for the nonleaf nodes from
t2
.
The syntax of
LOAD INDEX INTO CACHE
enables you to specify that only particular indexes from a
table should be preloaded. The current implementation preloads all the table's indexes into the cache,
so there is no reason to specify anything other than the table name.
LOAD INDEX INTO CACHE ... IGNORE LEAVES
fails unless all indexes in a table have the same
block size. (Prior to MySQL 5.0.87, it fails even without
IGNORE LEAVES
.) You can determine index
block sizes for a table by using
myisamchk -dv
and checking the
Blocksize
column.
13.7.6.5.
RESET
Syntax
RESET
reset_option
[,
reset_option
] ...
The
RESET
statement is used to clear the state of various server operations. You must have the
RELOAD
[577]
privilege to execute
RESET
.
RESET
acts as a stronger version of the
FLUSH
statement. See
Section 13.7.6.2, “
FLUSH
Syntax”
.
The
RESET
statement causes an implicit commit. See
Section 13.3.3, “Statements That Cause an
Implicit Commit”
.
reset_option
can be any of the following:
•
MASTER
Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates
a new binary log file.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...