Can't enable MySQL 5.6 Query Cache

Question

I'm trying to enable MySQL Query Cache on Ubuntu 15.04 with MySQL 5.6.25

I've added this to end end of /etc/mysql/my.cnf and /etc/mysql/conf.d/mysql.cnf:

query_cache_type = 1
query_cache_size = 4096M
query_cache_limit = 2M
query_cache_strip_comments =1

The whole server has been restarted more than once.

user@myhost:/$ mysql
mysql: unknown variable 'query_cache_type=1'

Using SHOW VARIABLES LIKE '%query_cache%' confirms that query_cache_type = OFF

SET GLOBAL query_cache_type = 1;
/* SQL Error (1651): Query cache is disabled; restart the server with query_cache_type=1 to enable it */

How can I solve this?

can you do a find -name "my.cnf" and see if you have any other my.cnf that may be on your server? — BK435
– BK435, Commented Jul 29, 2015 at 0:26
There are: ./etc/mysql/my.cnf ./etc/alternatives/my.cnf ./var/lib/dpkg/alternatives/my.cnf ./usr/my.cnf — bockzior
– bockzior, Commented Jul 29, 2015 at 0:57
where did you place your parameters in your my.cnf? under [mysqld]? — BK435
– BK435, Commented Jul 29, 2015 at 1:36

gilcierweb · Accepted Answer · 2016-03-16 02:07:11Z

4

edit file /etc/mysql/conf.d/mysql.cnf

add

[mysqld]
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

answered Mar 16, 2016 at 2:07

gilcierweb

2,7621 gold badge18 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mysql: [ERROR] unknown variable 'query_cache_type=1' I got this error while restarting mysqld