MySQLTuner tool
It’s here: http://mysqltuner.com/
Run it and then: mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
Go to my.cnf and add:
query_cache_size = 268435456query_cache_type=1query_cache_limit=1048576as it recommended.
Comments are currently closed.