Mysql: How to repair all mysql tables in MySQL?
Nov 06
How to repair in MYSQL all tables ?
Just run in console
1 | mysqlcheck -u root -p --auto-repair --check --optimize --all-databases -p[password] |
Where password – this is admin password!
Posts in ‘Unix-Linux’
How to – MySQL tuning in debian.
Sep 24
Results of compiling this scripts was recommendations how to change mysql params.
note. For best result please run MYSQL before testing – 48 hours!
1 2 3 | wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl ./mysqltuner.pl |
OR (also) try this script
1 2 | wget http://www.day32.com/MySQL/tuning-primer.sh sh tuning-primer.sh |