MySQL Tuning

1. Optimize tables (to correct overheads)
2. Set query cache size bigger if Qcache_lowmem_prunes (on the runtime information page) is red.

Useful commands:

• Show all query cache settings:
  SHOW VARIABLES LIKE  '%query_cache%';
• Set a bigger query cache size (256 MB) ON RUNTIME:
  SET GLOBAL query_cache_size = 256000000;
• Set a bigger query cache size in config (will work after mysql restart):
  /etc/mysql/my.cnf
  Search for "query_cache_size" then change...
  query_cache_size = 256M