mysqlcheck
mysqlcheck è uno strumento di manutenzione che permette di verificare, riparare, analizzare e ottimizzare più tabelle in una volta dalla riga di comando.
Utilizzo:
./client/mysqlcheck [OPZIONI] database [tabelle]
OR
./client/mysqlcheck [OPZIONI] --databases DB1 [DB2 DB3...]
OR
./client/mysqlcheck [OPZIONI] --all-databases
mysqlcheck serve a effettuare un CHECK (-c, -m, -C), un REPAIR (-r), un ANALYZE (-a) o un OPTIMIZE (-o). Alcune delle opzioni (come -e o -q) possono essere usate allo stesso tempo. Non tutte le opzioni sono supportate da tutti gli Storage Engine.
Le opzioni -c, -r, -a e -o sono mutualmente esclusive, il che significa che se si specificano più opzioni solo l'ultima verrà presa in considerazione.
L'opzione --check
mysqlrepair | L'opzione di default sarà -r ( |
mysqlanalyze | L'opzione di default sarà -a ( |
mysqloptimize | L'opzione di default sarà -o ( |
Vengono letti i gruppi [mysqlcheck] e [client] dai file my.cnf.
The following options to handle option files may be given as the first argument:
| Print the program argument list and exit. |
| Don't read default options from any option file. |
| Only read default options from the given file #. |
| Read this file after the global files are read. |
Main arguments are:
-A, | Check all the databases. This is the same as |
-a, | Analyze given tables. |
-1, | Instead of issuing one query for each table, use one query per database, naming all tables in the database in a comma-separated list. |
| If a checked table is corrupted, automatically fix it. Repairing will be done after all tables have been checked, if corrupted ones were found. |
| Directory for character set files. |
-c, | Check table for errors. |
-C, | Check only tables that have changed since last check or haven't been closed properly. |
-g, | Check tables for version-dependent changes. May be used with |
| Use compression in server/client protocol. |
-B, | Check several databases. Note the difference in usage; in this case no tables are given. All name arguments are regarded as database names. |
-# , | Output debug log. Often this is 'd:t:o,filename'. |
| Check memory and open file usage at exit. |
| Print some debug info at exit. |
| Set the default character set. |
-F, | Check only tables that haven't been closed properly. |
| Fix database names. Used when upgrading |
| Fix table names. Used when upgrading |
| Flush each table after check. This is useful if you don't want to have the checked tables take up space in the caches after the check. |
-f, | Continue even if we get an SQL error. |
-e, | If you are using this option with |
-?, | Display this help message and exit. |
-h, | Connect to host. |
-m, | Faster than extended-check, but only finds 99.99 percent of all errors. Should be good enough for most cases. |
| Log ANALYZE, OPTIMIZE and REPAIR TABLE commands. Enabled by default; use |
-o, | Optimize table. |
-p, | Password to use when connecting to server. If password is not given, it's solicited on the tty. |
-P, | Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306). |
| The protocol to use for connection (tcp, socket, pipe, memory). |
-q, | If you are using this option with CHECK TABLE, it prevents the check from scanning the rows to check for wrong links. This is the fastest check. If you are using this option with REPAIR TABLE, it will try to repair only the index tree. This is the fastest repair method for a table. |
-r, | Can fix almost anything except unique keys that aren't unique. |
-s, | Print only error messages. |
-S, | The socket file to use for connection. |
| Enable SSL for connection (automatically enabled with other flags). Disable with ' |
| CA file in PEM format (check OpenSSL docs, implies |
| CA directory (check OpenSSL docs, implies |
| X509 cert in PEM format (implies |
| SSL cipher to use (implies |
| X509 key in PEM format (implies |
| Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. |
| Overrides option |
| When used with REPAIR, get table structure from .frm file, so the table can be repaired even if .MYI header is corrupted. |
-u, | User for login if not current user. |
-v, | Print info about the various stages. You can give this option several times to get even more information. |
-V, | Output version information and exit. |
To see the default values for the options and also to see the arguments you get from configuration files you can do:
./client/mysqlcheck --print-defaults ./client/mysqlcheck --help
When running mysqlcheck with --auto-repairmysqlcheck will first
check all tables and then in a separate phase repair those that failed the
check.
mysqlcheck will ignore the MySQL internal log tables
'--all-databasesgeneral_log' and 'slow_log' as these can't be checked, repaired or
optimized.
