Linux - for mysql tunning use MySQLTuner script. MySQLTuner is a script written in perl that will assist you with your MySQL configuration & make recommendations for increased performance and stability. Download the latest MySQLTuner version in plain text to your ...

MySQL tuning - MySQL query cache: To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini) For linux /etc/my.cnf 1st: set query_cache_type to 1. (There are 3 possible ...