isamchk1
Description, check and repair of isam tables. used without options all tables on the command will be checked for errors
Usage
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}]
Usage
isamchk [OPTIONS] tables[.ISM]
Overview
|
Analyze distribution of keys. Will make some joins in MySQL faster. |
|---|---|
|
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 couple 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.
Releases
3 releases since Debian 2.2 (Potato); the text changed 2 times.
--character-sets-dir since Debian 3.0 (Woody).