Draft | Approver: psycore
Check and optimise mysql databases
Commands
Check
$ mysqlcheck -c -p[pass] -A
| Parameter | Alias | Meaning |
|---|---|---|
| --check | -c | Check tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |
Analyse
$ mysqlcheck -a -p[pass] -A
| Parameter | Alias | Meaning |
|---|---|---|
| --analyze | -a | Analyse tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |
Optimise
$ mysqlcheck -o -p[pass] -A
| Parameter | Alias | Meaning |
|---|---|---|
| --optimize | -o | Optimise tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |
Repair
$ mysqlcheck -r -p[pass] -A
| Parameter | Alias | Meaning |
|---|---|---|
| --repair | -r | Repair tables |
| --password | -p | Password (without spaces) |
| -all-databases | -A | All databases |