Bug #80312 maximum_query_cache_size cannot be set
Submitted: 9 Feb 2016 8:14 Modified: 9 Feb 2016 8:21
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.7.11 OS:CentOS (6.6)
Assigned to: CPU Architecture:Any

[9 Feb 2016 8:14] Tsubasa Tanaka
Doc says "You can set the maximum size that can be specified for the query cache at runtime with the SET statement by using the --maximum-query_cache_size=32M option on the command line or in the configuration file.", but that option cannot be set.


How to repeat:
# yum install -y http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
# yum install -y mysql-community-server
# echo "maximum_query_cache_size= 128M" >> /etc/my.cnf
# service mysqld start
Initializing MySQL database:  2016-02-09T08:08:53.675028Z 0 [ERROR] /usr/sbin/mysqld: Maximum value of 'query_cache_size' cannot be set
2016-02-09T08:08:53.675139Z 0 [ERROR] Aborting

[9 Feb 2016 8:21] MySQL Verification Team
Hello Tanaka-San,

Thank you for the report.