Required query-cache config changes missing
Bug #1275814 reported by
Richard van Katwijk
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
Related branches
lp:~hrvojem/percona-xtradb-cluster/bug1331866-5.5
- Raghavendra D Prabhu: Pending requested
-
Diff: 3554 lines (+18/-3305)17 files modifieddoc-pxc/Makefile (+1/-1)
doc-pxc/source/glossary.rst (+1/-1)
doc-pxc/source/howtos/virt_sandbox.rst (+1/-1)
doc-pxc/source/installation/apt_repo.rst (+7/-1)
doc-pxc/source/limitation.rst (+1/-1)
doc-pxc/source/manual/state_snapshot_transfer.rst (+1/-1)
doc-pxc/source/manual/xtrabackup_sst.rst (+2/-2)
doc-pxc/source/percona-theme/layout.html (+0/-382)
doc-pxc/source/percona-theme/searchbox.html (+0/-22)
doc-pxc/source/percona-theme/static/default.css_t (+0/-433)
doc-pxc/source/percona-theme/static/jquery.min.js (+0/-154)
doc-pxc/source/percona-theme/static/percona.com.css (+0/-1850)
doc-pxc/source/percona-theme/static/percona.com.js (+0/-269)
doc-pxc/source/percona-theme/static/sidebar.js (+0/-151)
doc-pxc/source/percona-theme/theme.conf (+0/-32)
doc-pxc/source/release-notes/Percona-XtraDB-Cluster-5.5.34-23.7.6.rst (+1/-1)
doc-pxc/source/wsrep-system-index.rst (+3/-3)
lp:~hrvojem/percona-xtradb-cluster/bug1275814-5.6
- Raghavendra D Prabhu: Pending requested
-
Diff: 24 lines (+3/-2)2 files modifieddoc-pxc/source/conf.py (+2/-2)
doc-pxc/source/limitation.rst (+1/-0)
To post a comment you must log in.
@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.