myisamchk
— MyISAM Table-Maintenance Utility
319
that has died without closing the file properly, which can sometimes lead to the
corruption of one or more
MyISAM
tables.
If
mysqld
is running, you must force it to flush any table modifications that are
still buffered in memory by using
FLUSH TABLES
. You should then ensure that
no one is using the tables while you are running
myisamchk
However, the easiest way to avoid this problem is to use
CHECK TABLE
instead
of
myisamchk
to check tables. See
Section 13.7.2.3, “
CHECK TABLE
Syntax”
.
myisamchk
supports the following options, which can be specified on the command line or in the
[myisamchk]
group of an option file.
myisamchk
also supports the options for processing option files
described at
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
.
Table 4.8.
myisamchk
Options
Format
Option File
Description
--analyze [325]
analyze [325]
Analyze the distribution of key values
--backup [323]
backup [323]
Make a backup of the .MYD file as file_name-time.BAK
--block-
search=offset [325]
block-search [325]
Find the record that a block at the given offset belongs to
--check [322]
check [322]
Check the table for errors
--check-only-
changed [323]
check-only-
changed [323]
Check only tables that have changed since the last check
--correct-
checksum [324]
correct-
checksum [324]
Correct the checksum information for the table
--data-file-
length=len [324]
data-file-
length [324]
Maximum length of the data file (when re-creating data
file when it is full)
--
debug[=debug_options] [321]
debug [321]
Write a debugging log
decode_bits=#
decode_bits
Decode_bits
--description [325]
description [325]
Print some descriptive information about the table
--extend-
check [323]
extend-check [323]
Do very thorough table check or repair that tries to
recover every possible row from the data file
--fast [323]
fast [323]
Check only tables that haven't been closed properly
--force [323]
force [323]
Do a repair operation automatically if myisamchk finds
any errors in the table
--force
force-recover
Overwrite old temporary files. For use with the -r or -o
option
ft_max_word_len=#
ft_max_word_len
Maximum word length for FULLTEXT indexes
ft_min_word_len=#
ft_min_word_len
Minimum word length for FULLTEXT indexes
ft_stopword_file=valueft_stopword_file
Use stopwords from this file instead of built-in list
--HELP [321]
Display help message and exit
--help [321]
Display help message and exit
--information [323]
information [323]
Print informational statistics about the table that is
checked
key_buffer_size=#
key_buffer_size
The size of the buffer used for index blocks for MyISAM
tables
--keys-
used=val [324]
keys-used [324]
A bit-value that indicates which indexes to update
Содержание 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 ...