ISAMCHK

NAME
USAGE
SYNOPSIS
DESCRIPTION
SEE ALSO
AUTHOR

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 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.

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), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com)