本篇內(nèi)容介紹了“mysqlcheck的常用語(yǔ)法總結(jié)”的有關(guān)知識(shí)，在實(shí)際案例的操作過(guò)程中，不少人都會(huì)遇到這樣的困境，接下來(lái)就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧！希望大家仔細(xì)閱讀，能夠?qū)W有所成！
以下內(nèi)容主要適用于mysql 5.6，5.5的版本可能有部分選項(xiàng)不可用。
通常使用該工具一般語(yǔ)法為：
| Format | Description | Introduced |
|---|---|---|
| --all-databases | Check all tables in all databases | |
| --all-in-1 | Execute a single statement for each database that names all the tables from that database | |
| --analyze | Analyze the tables | |
| --auto-repair | If a checked table is corrupted, automatically fix it | |
| --bind-address=ip_address | Use specified network interface to connect to MySQL Server | |
| --character-sets-dir=path | Directory where character sets are installed | |
| --check | Check the tables for errors | |
| --check-only-changed | Check only tables that have changed since the last check | |
| --check-upgrade | Invoke CHECK TABLE with the FOR UPGRADE option | |
| --compress | Compress all information sent between client and server | |
| --databases | Process all tables in the named databases | |
| --debug[=debug_options] | Write a debugging log | |
| --debug-check | Print debugging information when program exits | |
| --debug-info | Print debugging information, memory, and CPU statistics when program exits | |
| --default-auth=plugin | Authentication plugin to use | 5.6.2 |
| --default-character-set=charset_name | Specify default character set | |
| --defaults-extra-file=file_name | Read option file in addition to usual option files | |
| --defaults-file=file_name | Read only named option file | |
| --defaults-group-suffix=str | Option group suffix value | |
| --extended | Check and repair tables | |
| --fast | Check only tables that have not been closed properly | |
| --fix-db-names | Convert database names to 5.1 format | |
| --fix-table-names | Convert table names to 5.1 format | |
| --force | Continue even if an SQL error occurs | |
| --help | Display help message and exit | |
| --host=host_name | Connect to MySQL server on given host | |
| --login-path=name | Read login path options from .mylogin.cnf | 5.6.6 |
| --medium-check | Do a check that is faster than an --extended operation | |
| --no-defaults | Read no option files | |
| --optimize | Optimize the tables | |
| --password[=password] | Password to use when connecting to server | |
| --pipe | On Windows, connect to server using named pipe | |
| --plugin-dir=path | Directory where plugins are installed | 5.6.2 |
| --port=port_num | TCP/IP port number to use for connection | |
| --print-defaults | Print defaults | |
| --protocol=type | Connection protocol to use | |
| --quick | The fastest method of checking | |
| --repair | Perform a repair that can fix almost anything except unique keys that are not unique | |
| --secure-auth | Do not send passwords to the server in old (pre-4.1.1) format | 5.6.17 |
| --shared-memory-base-name=name | The name of shared memory to use for shared-memory connections | |
| --silent | Silent mode | |
| --skip-database=db_name | Omit this database from performed operations | 5.6.11 |
| --socket=path | For connections to localhost, the Unix socket file to use | |
| --ssl | Enable SSL for connection | |
| --ssl-ca=file_name | Path of file that contains list of trusted SSL CAs | |
| --ssl-capath=dir_name | Path of directory that contains trusted SSL CA certificates in PEM format | |
| --ssl-cert=file_name | Path of file that contains X509 certificate in PEM format | |
| --ssl-cipher=cipher_list | List of permitted ciphers to use for SSL encryption | |
| --ssl-crl=file_name | Path of file that contains certificate revocation lists | 5.6.3 |
| --ssl-crlpath=dir_name | Path of directory that contains certificate revocation list files | 5.6.3 |
| --ssl-key=file_name | Path of file that contains X509 key in PEM format | |
| --ssl-verify-server-cert | Verify server Common Name value in its certificate against host name used when connecting to server | |
| --tables | Overrides the --databases or -B option | |
| --use-frm | For repair operations on MyISAM tables | |
| --user=user_name, | MySQL user name to use when connecting to server | |
| --verbose | Verbose mode | |
| --version | Display version information and exit | |
| --write-binlog | Log ANALYZE, OPTIMIZE, REPAIR statements to binary log. --skip-write-binlog adds NO_WRITE_TO_BINLOG to these statements. |
“mysqlcheck的常用語(yǔ)法總結(jié)”的內(nèi)容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識(shí)可以關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司網(wǎng)站，小編將為大家輸出更多高質(zhì)量的實(shí)用文章！
重慶分公司
重慶分公司
