query_cache_* configuration not appropriate for all mysql alternatives
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.5 (Ubuntu) |
Invalid
|
Low
|
Unassigned | ||
Trusty |
Invalid
|
Low
|
Unassigned | ||
percona-xtradb-cluster-5.5 (Ubuntu) |
Fix Released
|
High
|
James Page | ||
Trusty |
Fix Released
|
High
|
James Page |
Bug Description
my.cnf as provided in the mysql-common package sets:
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
percona-
ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: mysql-common 5.5.35+
ProcVersionSign
Uname: Linux 3.13.0-12-generic x86_64
ApportVersion: 2.13.3-0ubuntu1
Architecture: amd64
Date: Mon Mar 10 11:58:33 2014
Dependencies:
Ec2AMI: ami-00000036
Ec2AMIManifest: FIXME
Ec2Availability
Ec2InstanceType: m1.small
Ec2Kernel: aki-00000002
Ec2Ramdisk: ari-00000002
PackageArchitec
ProcEnviron:
TERM=screen-
PATH=(custom, no user)
XDG_RUNTIME_
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)
mtime.conffile.
Related branches
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
importance: | Undecided → High |
Changed in mysql-5.5 (Ubuntu Trusty): | |
importance: | Undecided → Low |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
status: | New → Triaged |
Changed in mysql-5.5 (Ubuntu Trusty): | |
status: | New → Triaged |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
assignee: | nobody → James Page (james-page) |
status: | Triaged → In Progress |
Changed in mysql-5.5 (Ubuntu Trusty): | |
status: | Triaged → Invalid |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
status: | In Progress → Fix Committed |
Just a brief comment from upstream:
Turning off query cache is an acceptable resolution. It is off by default from MySQL 5.6+ www.tocker. ca/2013/ 09/10/improving -mysqls- default- configuration. html
http://
(The query cache mutex is hot on multi-core systems.)