Enable the query cache in MySQL to improve performance

from mysql server

$ mysql -u root –p

set cache inside mysql shell



mysql> SET GLOBAL query_cache_size = 16777216;

mysql> SHOW VARIABLES LIKE 'query_cache_size';

exit and edit my.cnf

(on ubuntu)
cd /etc/mysql/my.cnf

# nano /etc/my.cnf

add

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576