![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196467.webp)
Server System Variables
447
•
delay_key_write
[447]
Command-Line Format
--delay-key-write[=name]
Option-File Format
delay-key-write
Option Sets Variable
Yes,
delay_key_write
[447]
Variable Name
delay-key-write
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
enumeration
Default
ON
Valid
Values
ON
OFF
ALL
This option applies only to
MyISAM
tables. It can have one of the following values to affect handling
of the
DELAY_KEY_WRITE
table option that can be used in
CREATE TABLE
statements.
Option
Description
OFF
DELAY_KEY_WRITE
is ignored.
ON
MySQL honors any
DELAY_KEY_WRITE
option specified in
CREATE TABLE
statements. This is the default value.
ALL
All new opened tables are treated as if they were created with the
DELAY_KEY_WRITE
option enabled.
If
DELAY_KEY_WRITE
is enabled for a table, the key buffer is not flushed for the table on every index
update, but only when the table is closed. This speeds up writes on keys a lot, but if you use this
feature, you should add automatic checking of all
MyISAM
tables by starting the server with the
--
myisam-recover
[415]
option (for example,
--myisam-recover=BACKUP,FORCE
[415]
). See
Section 5.1.3, “Server Command Options”
, and
Section 14.1.1, “
MyISAM
Startup Options”
.
Warning
If you enable external locking with
--external-locking
[408]
, there is
no protection against index corruption for tables that use delayed key writes.
•
delayed_insert_limit
[447]
Command-Line Format
--delayed_insert_limit=#
Option-File Format
delayed_insert_limit
Option Sets Variable
Yes,
delayed_insert_limit
[447]
Variable Name
delayed_insert_limit
Variable Scope
Global
Dynamic Variable
Yes
Deprecated
5.6.7
Permitted Values
Platform
Bit Size
32
Содержание 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 ...