|
NAME
isamchk
- Description, check and repair of ISAM tables. Used without options
all tables on the command will be checked for errors
USAGE
isamchk [OPTIONS] tables[.ISM]
SYNOPSIS
isamchk [-a|--analyze] [-#|--debug=...] [--character-sets-dir=...]
[-C|--default-character-set=...] [-d|--description]
[-e|--extend-check] [-f|--force] [-?|--help] [-i|--information]
[-k|--keys-used=#] [-l|--no-symlinks] [-q|--quick] [-r|--recover]
[-o|--safe-recover] [-O|--set-variable var=option] [-s|--silent]
[-S|--sort-index] [-R|--sort-records=#] [-u|--unpack] [-v|--verbose]
[-V|--version] [-w|--wait]
DESCRIPTION
-a|--analyze
Analyze distribution of keys. Will make some joins in MySQL
faster.
-#|--debug=...
Output debug log. Often this is 'd:t:o ,filename`
--character-sets-dir=...
Directory where character sets are
-C|--default-character-set=...
Set the default character set
-d|--description
Prints some information about table.
-e|--extend-check
Check the table VERY thoroughly. One need use this only in
extreme cases as isamchk should normally find all errors even
without this switch
-f|--force
Overwrite old temporary files. If one uses -f when checking
tables (running isamchk without -r), isamchk will automatically
restart with -r on any wrong table.
-?|--help
Display help and exit.
-i|--information
Print statistics information about the table
-k|--keys-used=#
Used with '-r'. Tell ISAM to update only the first # keys. This
can be used to get faster inserts!
-l|--no-symlinks
Do not follow symbolic links when repairing. Normally isamchk
repairs the table a symlink points at.
-q|--quick
Used with -r to get a faster repair. (The data file isn't
touched.) One can give a second '-q' to force isamchk to modify
the original datafile.
-r|--recover
Can fix almost anything except unique keys that aren't unique.
-o|--safe-recover
Uses old recovery method; slower than '-r' but can handle a cou-
ple of cases that '-r' cannot handle.
-O| --set-variable var=option
Change the value of a variable.
-s|--silent
Only print errors. One can use two -s to make isamchk very
silent
-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!)
-u|--unpack
Unpack file packed with pack_isam.
-v|--verbose
Print more information. This can be used with -d and -e. Use
many -v for more verbosity!
-V|--version
Print version and exit.
-w|--wait
Wait if table is locked.
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug
(1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se),
TCX Datakonsult AB (http://www.tcx.se). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mer-
curmedia Data Model Architect / system developer (http://www.mercurme-
dia.com)
|