mysql optimize & repair all db

repair

mysqlcheck --all-databases --auto-repair --silent -u root -p

optimize

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to improve playback of lower-latency Apple HLS streams (Wowza)

In Wowza Streaming Engine Manager, click the Applications tab and then click live in the...

DirectAdmin: Improve performance and security

In this tutorial, I'm going to improve the DirectAdmin environment, make it faster and more...

Reverse DNS

Linux curl http://freedns.icez.net/rdns.php?hostname=xx.domain.com Windows Open Web Browser...

mysql restore & backup

restore mysql -u username -p dbname < /path/file.sql backup mysqldump -u username -p dbname...