Performance Tuning

Various tips and suggestions for optimizing MySQL performance.

MySQLTuner
http://blog.mysqltuner.com
Tuning MySQL Performance with MySQLTuner
Download the MySQLTuner script:

cd /extra/src
wget http://mysqltuner.pl/ -O mysqltuner.pl

Running it is very simple:

perl mysqltuner.pl

After entering your MySQL root username and password, the script will output a variety of stats on your MySQL server and suggestions to improve the performance.

Optimize tables
mysqlcheck -u root -p --auto-repair --optimize

Recent Updates

  • 3 months 3 weeks ago
  • 3 months 3 weeks ago
  • 3 months 3 weeks ago
    php 8.x
  • 3 months 3 weeks ago
    10.6.7
  • 3 months 4 weeks ago
    Drop Centos 5/6 stuff