Required query-cache config changes missing

Bug #1275814 reported by Richard van Katwijk on 2014-02-03
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Fix Released
High
Hrvoje Matijakovic
5.6
Fix Released
High
Hrvoje Matijakovic

Bug Description

[In:Percona XtraDB Cluster Documentation]

Please add a note to the my.cnf configuration options to mention that query_cache parameters need to be disabled - this caught me out several times:

# Query Cache is not supported with wsrep
query_cache_size=0
query_cache_type=0

Thanks

Tags: doc Edit Tag help

Related branches

@Richard,

Thanks for reporting. The documentation indeed needs to be updated, especially, since now it is possible to enable query cache at runtime for galera.

a)

To quote from https://bugs.launchpad.net/codership-mysql/+bug/1248089/comments/3:

 "To enable query cache, mysqld should be started with query_cache_type=1 and query_cache_size=0 and then query_cache_size should be changed to desired value during runtime."

b)
Also, limitations page needs to be updated.

The 5.6.15-25.3 and 25.4 already support query cache as in #1, so 5.6 documentation needs to be updated.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-993

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers