Bug #70251 query_cache_type should default to 1

• Submitted: 5 Sep 2013 14:12
• Modified: 19 Sep 2013 19:11
• Reporter: John Paterson
• Status: Won't fix
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.6
• OS: Any
• CPU Architecture: Any
• Tags: 5.6, innodb, query cache, server variables

[5 Sep 2013 14:12] John Paterson

Description:
In previous versions (5.1 and below) setting a value for query_cache_size was sufficient to turn on the query cache.

Now we have to set a value for query_cache_size and set query_cache_type=1 (or 2)

It would make more sense for query_cache_type to default to 1 on installation.

We rebuilt some servers for our crm system and couldn't work out why response was slow until we trawled through my.ini and found the new (for us) setting!

Thanks!
John Paterson
http://www.reallysimplesystems.com
Making CRM Simple

How to repeat:
Install a new instance of MySQL 5.6

Suggested fix:
Set query_cache_type to default to 1 on installation

[19 Sep 2013 19:11] MySQL Verification Team

This change was made for a reason that it's better for majority of users.
http://dev.mysql.com/doc/refman/5.6/en/server-default-changes.html