Query caching for MySQL can speed queries from users by saving the results in ram.
Our server had high traffic and 100% CPU processing – (Lynix server)
Fix:
- SSH into server with putty etc.
- backup my.cnf ( sudo cp .my.cnf .my.cnf_bak )
- edit the config file ( nano .my.cnf )
- add :
query_cache_type = 1
query_cache_size = 128M (or different values etc.) - Ctrl X, Y, enter (save/close)