Table of Contents

Check and optimise mysql databases
- Commands
  - Check
  - Analyse
  - Optimise
  - Repair

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