Easy way to optimize apache,php & MySQL
February 2nd, 2010 Posted in MySQL, PHP, System Administration, Web hosting, cpanel
There are 2 important scripts to optimize apache,php and mysql very easily. They are
MySQLTuner (Perl) and MySQL Performance Tuning Primer (shell)
They can help diagnose MySQL database performance issues, and provide recommendations on how to solve them.
# Download MySQLTuner and MySQL Performance Tuning Primer to ~/scripts. # To avoid having to invoke Perl/SH each time, make both files executable. chmod +x ~/scripts/mysqltuner.pl chmod +x ~/scripts/tuning-primer.sh # After that, give them a go! ~/scripts/mysqltuner.pl ~/scripts/tuning-primer.sh