반응형
# myisamchk --help
myisamchk Ver 2.6 for pc-solaris2.9 at i386
By Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.
Description, check and repair of MyISAM tables.
Used without options all tables on the command will be checked for errors
Usage: myisamchk [OPTIONS] tables[.MYI]
Global options:
-#, --debug=debug_options
Output debug log. The debug_option string often is 'd:t:o,filename'
-?, --help Display this help and exit.
-O, --set-variable var=option
Change the value of a variable. Please note that
this option is deprecated; you can set variables
directly with '--variable-name=value'.
-t, --tmpdir=path Path for temporary files. Multiple paths can be
specified, separated by colon (:), they will be used
in a round-robin fashion.
-s, --silent only print errors. one can use two -s to make
myisamchk very silent
-v, --verbose Print more information. This can be used with
--description and --check. Use many -v for more verbosity!
-V, --version Print version and exit.
-w, --wait Wait if table is locked.
Check options (check is the default action for myisamchk):
-c, --check Check table for errors
-e, --extend-check Check the table VERY throughly. only use this in
extreme cases as myisamchk should normally be able to
find out if the table is ok even without this switch
-F, --fast Check only tables that haven't been closed properly
-C, --check-only-changed
Check only tables that have changed since last check
-f, --force Restart with '-r' if there are any errors in the table.
States will be updated as with '--update-state'
-i, --information Print statistics information about table that is checked
-m, --medium-check Faster than extend-check, but only finds 99.99% of
all errors. Should be good enough for most cases
-U --update-state Mark tables as crashed if you find any errors
-T, --read-only Don't mark table as checked
Repair options (When using '-r' or '-o')
-B, --backup Make a backup of the .MYD file as 'filename-time.BAK'
--correct-checksum Correct checksum information for table.
-D, --data-file-length=# Max length of data file (when recreating data
file when it's full)
-e, --extend-check Try to recover every possible row from the data file
Normally this will also find a lot of garbage rows;
Don't use this option if you are not totally desperate.
-f, --force Overwrite old temporary files.
-k, --keys-used=# Tell MyISAM to update only some specific keys. # is a
bit mask of which keys to use. This can be used to
get faster inserts!
-r, --recover Can fix almost anything except unique keys that aren't
unique.
-n, --sort-recover Forces recovering with sorting even if the temporary
file would be very big.
-p, --parallel-recover
Uses the same technique as '-r' and '-n', but creates
all the keys in parallel, in different threads.
THIS IS ALPHA CODE. USE AT YOUR OWN RISK!
-o, --safe-recover Uses old recovery method; Slower than '-r' but can
handle a couple of cases where '-r' reports that it
can't fix the data file.
--character-sets-dir=...
Directory where character sets are
--set-character-set=name
Change the character set used by the index
-q, --quick Faster repair by not modifying the data file.
one can give a second '-q' to force myisamchk to
modify the original datafile in case of duplicate keys
-u, --unpack Unpack file packed with myisampack.
Other actions:
-a, --analyze Analyze distribution of keys. Will make some joins in
MySQL faster. You can check the calculated distribution
by using '--description --verbose table_name'.
-d, --description Prints some information about table.
-A, --set-auto-increment[=value]
Force auto_increment to start at this or higher value
If no value is given, then sets the next auto_increment
value to the highest used value for the auto key + 1.
-S, --sort-index Sort index blocks. This speeds up 'read-next' in
applications
-R, --sort-records=#
Sort records according to an index. This makes your
data much more localized and may speed up things
(It may be VERY slow to do a sort the first time!)
-b, --block-search=#
Find a record, a block at given offset belongs to.
Default options are read from the following files in the given order:
/etc/my.cnf /export/home/mysql/var/my.cnf ~/.my.cnf
The following groups are read: myisamchk
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
character-sets-dir (No default value)
data-file-length 0
keys-used 18446744073709551615
set-auto-increment 0
sort-records 0
tmpdir (No default value)
key_buffer_size 20967424
myisam_block_size 1024
read_buffer_size 2097144
write_buffer_size 2097144
sort_buffer_size 20971512
sort_key_blocks 16
decode_bits 9
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
#
myisamchk Ver 2.6 for pc-solaris2.9 at i386
By Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.
Description, check and repair of MyISAM tables.
Used without options all tables on the command will be checked for errors
Usage: myisamchk [OPTIONS] tables[.MYI]
Global options:
-#, --debug=debug_options
Output debug log. The debug_option string often is 'd:t:o,filename'
-?, --help Display this help and exit.
-O, --set-variable var=option
Change the value of a variable. Please note that
this option is deprecated; you can set variables
directly with '--variable-name=value'.
-t, --tmpdir=path Path for temporary files. Multiple paths can be
specified, separated by colon (:), they will be used
in a round-robin fashion.
-s, --silent only print errors. one can use two -s to make
myisamchk very silent
-v, --verbose Print more information. This can be used with
--description and --check. Use many -v for more verbosity!
-V, --version Print version and exit.
-w, --wait Wait if table is locked.
Check options (check is the default action for myisamchk):
-c, --check Check table for errors
-e, --extend-check Check the table VERY throughly. only use this in
extreme cases as myisamchk should normally be able to
find out if the table is ok even without this switch
-F, --fast Check only tables that haven't been closed properly
-C, --check-only-changed
Check only tables that have changed since last check
-f, --force Restart with '-r' if there are any errors in the table.
States will be updated as with '--update-state'
-i, --information Print statistics information about table that is checked
-m, --medium-check Faster than extend-check, but only finds 99.99% of
all errors. Should be good enough for most cases
-U --update-state Mark tables as crashed if you find any errors
-T, --read-only Don't mark table as checked
Repair options (When using '-r' or '-o')
-B, --backup Make a backup of the .MYD file as 'filename-time.BAK'
--correct-checksum Correct checksum information for table.
-D, --data-file-length=# Max length of data file (when recreating data
file when it's full)
-e, --extend-check Try to recover every possible row from the data file
Normally this will also find a lot of garbage rows;
Don't use this option if you are not totally desperate.
-f, --force Overwrite old temporary files.
-k, --keys-used=# Tell MyISAM to update only some specific keys. # is a
bit mask of which keys to use. This can be used to
get faster inserts!
-r, --recover Can fix almost anything except unique keys that aren't
unique.
-n, --sort-recover Forces recovering with sorting even if the temporary
file would be very big.
-p, --parallel-recover
Uses the same technique as '-r' and '-n', but creates
all the keys in parallel, in different threads.
THIS IS ALPHA CODE. USE AT YOUR OWN RISK!
-o, --safe-recover Uses old recovery method; Slower than '-r' but can
handle a couple of cases where '-r' reports that it
can't fix the data file.
--character-sets-dir=...
Directory where character sets are
--set-character-set=name
Change the character set used by the index
-q, --quick Faster repair by not modifying the data file.
one can give a second '-q' to force myisamchk to
modify the original datafile in case of duplicate keys
-u, --unpack Unpack file packed with myisampack.
Other actions:
-a, --analyze Analyze distribution of keys. Will make some joins in
MySQL faster. You can check the calculated distribution
by using '--description --verbose table_name'.
-d, --description Prints some information about table.
-A, --set-auto-increment[=value]
Force auto_increment to start at this or higher value
If no value is given, then sets the next auto_increment
value to the highest used value for the auto key + 1.
-S, --sort-index Sort index blocks. This speeds up 'read-next' in
applications
-R, --sort-records=#
Sort records according to an index. This makes your
data much more localized and may speed up things
(It may be VERY slow to do a sort the first time!)
-b, --block-search=#
Find a record, a block at given offset belongs to.
Default options are read from the following files in the given order:
/etc/my.cnf /export/home/mysql/var/my.cnf ~/.my.cnf
The following groups are read: myisamchk
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
character-sets-dir (No default value)
data-file-length 0
keys-used 18446744073709551615
set-auto-increment 0
sort-records 0
tmpdir (No default value)
key_buffer_size 20967424
myisam_block_size 1024
read_buffer_size 2097144
write_buffer_size 2097144
sort_buffer_size 20971512
sort_key_blocks 16
decode_bits 9
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
#
반응형