The OpenNET Project / Index page

[ новости/++ | форум | wiki | теги | ]

Интерактивная система просмотра системных руководств (man-ов)

 [Cписок руководств | Печать]

isamchk (1)
  • >> isamchk (1) ( Linux man: Команды и прикладные программы пользовательского уровня )


     - Description, check and repair of ISAM tables. Used without options all tables on the command will be checked for errors  


    isamchk [OPTIONS] tables[.ISM]  


    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]  


    Analyze distribution of keys. Will make some joins in MySQL faster.
    Output debug log. Often this is 'd:t:o ,filename`
    Directory where character sets are
    Set the default character set
    Prints some information about table.
    Check the table VERY thoroughly. One need use this only in extreme cases as isamchk should normally find all errors even without this switch
    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.
    Display help and exit.
    Print statistics information about the table
    Used with '-r'. Tell ISAM to update only the first # keys. This can be used to get faster inserts!
    Do not follow symbolic links when repairing. Normally isamchk repairs the table a symlink points at.
    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.
    Can fix almost anything except unique keys that aren't unique.
    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.
    Only print errors. One can use two -s to make isamchk very silent
    Sort index blocks. This speeds up 'read-next' in applications
    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!)
    Unpack file packed with pack_isam.
    Print more information. This can be used with -d and -e. Use many -v for more verbosity!
    Print version and exit.
    Wait if table is locked.


    isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at  


    Please refer to to report bugs.  


    Ver 1.0, distribution 4.0.20 Michael (Monty) Widenius (, MySQL AB ( This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (, Mercurmedia Data Model Architect / system developer (




    Поиск по тексту MAN-ов: 

      Закладки на сайте
      Проследить за страницей
    Created 1996-2017 by Maxim Chirkov  
    Hosting by Ihor