mysqlcheck的常用语法总结

127次阅读

共计 3465 个字符，预计需要花费 9 分钟才能阅读完成。

本篇内容介绍了“mysqlcheck 的常用语法总结”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让丸趣 TV 小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

以下内容主要适用于 mysql 5.6，5.5 的版本可能有部分选项不可用。

通常使用该工具一般语法为：

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.