![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196426.webp)
Server Command Options
406
Option-File Format
default-storage-engine
Variable Name
storage_engine
Variable Scope
Global, Session
Dynamic Variable
Yes
Set the default storage engine (table type) for tables. See
Chapter 14, Storage Engines
.
•
--default-table-type=type
[406]
Version Deprecated
5.0
Command-Line Format
--default-table-type=name
Option-File Format
default-table-type
Deprecated
5.0, by
default-storage-engine
Permitted Values
Type
string
This option is a deprecated synonym for
--default-storage-engine
[405]
.
•
--default-time-zone=timezone
[406]
Command-Line Format
--default-time-zone=name
Option-File Format
default-time-zone
Permitted Values
Type
string
Set the default server time zone. This option sets the global
time_zone
[500]
system variable.
If this option is not given, the default time zone is the same as the system time zone (given by the
value of the
system_time_zone
[498]
system variable.
•
--delay-key-write[={OFF|ON|ALL}]
[406]
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
Specify how to use delayed key writes. Delayed key writing causes key buffers not to be flushed
between writes for
MyISAM
tables.
OFF
disables delayed key writes.
ON
enables delayed key writes
for those tables that were created with the
DELAY_KEY_WRITE
option.
ALL
delays key writes for
all
MyISAM
tables. See
Section 8.9.2, “Tuning Server Parameters”
, and
Section 14.1.1, “
MyISAM
Startup Options”
.
Содержание 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 ...