The OpenNET Project / Index page

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

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

 ТемаНаборКатегория 
 
 [Cписок руководств | Печать]

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

    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

    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 http://www.mysql.com/doc/en/  

    BUGS

    Please refer to http://bugs.mysql.com/ to report bugs.  

    AUTHOR

    Ver 1.0, distribution 4.0.20 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). 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)


     

    Index

    NAME
    USAGE
    SYNOPSIS
    DESCRIPTION
    SEE ALSO
    BUGS
    AUTHOR


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




    Партнёры:
    PostgresPro
    Inferno Solutions
    Hosting by Hoster.ru
    Хостинг:

    Закладки на сайте
    Проследить за страницей
    Created 1996-2024 by Maxim Chirkov
    Добавить, Поддержать, Вебмастеру