![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196440.webp)
Server Command Options
420
•
--shared-memory
[420]
Enable shared-memory connections by local clients. This option is available only on Windows.
•
--shared-memory-base-name=name
[420]
The name of shared memory to use for shared-memory connections. This option is available only on
Windows. The default name is
MYSQL
. The name is case sensitive.
•
--skip-bdb
[420]
Disable the
BDB
storage engine. This saves memory and might speed up some operations. Do not
use this option if you require
BDB
tables.
•
--skip-concurrent-insert
[420]
Turn off the ability to select and insert at the same time on
MyISAM
tables. (This is to be used only if
you think you have found a bug in this feature.) See
Section 8.7.3, “Concurrent Inserts”
.
•
--skip-external-locking
[420]
Do not use external locking (system locking). This affects only
MyISAM
table access. For more
information, including conditions under which it can and cannot be used, see
Section 8.7.4, “External
Locking”
.
External locking has been disabled by default since MySQL 4.0.
•
--skip-grant-tables
[420]
This option causes the server to start without using the privilege system at all, which gives anyone
with access to the server unrestricted access to all databases. You can cause a running server to
start using the grant tables again by executing
mysqladmin flush-privileges
or
mysqladmin
reload
command from a system shell, or by issuing a MySQL
FLUSH PRIVILEGES
statement after
connecting to the server. This option also suppresses loading of user-defined functions (UDFs).
Note that
FLUSH PRIVILEGES
might be executed implicitly by other actions performed after startup.
For example,
mysql_upgrade
flushes the privileges during the upgrade procedure.
This option is unavailable if MySQL was configured with the
--disable-grant-options
[123]
option. See
Section 2.17.3, “MySQL Source-Configuration Options”
.
•
--skip-host-cache
[420]
Disable use of the internal host cache for faster name-to-IP resolution. In this case, the server
performs a DNS lookup every time a client connects. See
Section 8.9.8, “DNS Lookup Optimization
and the Host Cache”
.
•
--skip-innodb
[1236]
Disable the
InnoDB
storage engine. In this case, the server will not start if the default storage engine
is set to
InnoDB
. Use
--default-storage-engine
[405]
to set the default to some other
engine if necessary.
•
--skip-merge
[420]
Disable the
MERGE
storage engine. This option was added in MySQL 5.0.24. It can be used if the
following behavior is undesirable: If a user has access to
MyISAM
table
t
, that user can create a
MERGE
table
m
that accesses
t
. However, if the user's privileges on
t
are subsequently revoked, the
user can continue to access
t
by doing so through
m
.
•
--skip-name-resolve
[420]
Содержание 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 ...