Server Command Options
416
Option Sets Variable
Yes,
myisam_recover_options
[475]
Permitted Values
Type
enumeration
Default
OFF
Valid
Values
DEFAULT
BACKUP
FORCE
QUICK
Set the
MyISAM
storage engine recovery mode. The option value is any combination of the values
of
DEFAULT
,
BACKUP
,
FORCE
, or
QUICK
. If you specify multiple values, separate them by commas.
Specifying the option with no argument is the same as specifying
DEFAULT
, and specifying with an
explicit value of
""
disables recovery (same as not giving the option). If recovery is enabled, each
time
mysqld
opens a
MyISAM
table, it checks whether the table is marked as crashed or was not
closed properly. (The last option works only if you are running with external locking disabled.) If this
is the case,
mysqld
runs a check on the table. If the table was corrupted,
mysqld
attempts to repair
it.
The following options affect how the repair works.
Option
Description
DEFAULT
Recovery without backup, forcing, or quick checking.
BACKUP
If the data file was changed during recovery, save a backup of the
tbl_name.MYD
file as
tbl_name-datetime.BAK
.
FORCE
Run recovery even if we would lose more than one row from the
.MYD
file.
QUICK
Do not check the rows in the table if there are not any delete blocks.
Before the server automatically repairs a table, it writes a note about the repair to the error log. If you
want to be able to recover from most problems without user intervention, you should use the options
BACKUP,FORCE
. This forces a repair of a table even if some rows would be deleted, but it keeps the
old data file as a backup so that you can later examine what happened.
See
Section 14.1.1, “
MyISAM
Startup Options”
.
•
--old-style-user-limits
[416]
Version Introduced
5.0.3
Command-Line Format
--old-style-user-limits
Option-File Format
old-style-user-limits
Permitted Values
Type
boolean
Default
FALSE
Enable old-style user limits. (Before MySQL 5.0.3, account resource limits were counted separately
for each host from which a user connected rather than per account row in the
user
table.) See
Section 6.3.4, “Setting Account Resource Limits”
. This option was added in MySQL 5.0.3.
•
--one-thread
[416]
Command-Line Format
--one-thread
Содержание 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 ...