Ubuntu
mysql-5.5 package

query_cache_* configuration not appropriate for all mysql alternatives

Bug #1290331 reported by James Page
6
This bug affects 1 person
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-cluster-xtradb-common-5.5 depends on mysql-common, however for this mysql alternative, these configuration setting result in a server that won't start (query cache is disabled in active-active HA mysql).

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: mysql-common 5.5.35+dfsg-1ubuntu1
ProcVersionSignature: User Name 3.13.0-12.32-generic 3.13.4
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
Ec2AvailabilityZone: serverstack-az-1
Ec2InstanceType: m1.small
Ec2Kernel: aki-00000002
Ec2Ramdisk: ari-00000002
PackageArchitecture: all
ProcEnviron:
 TERM=screen-256color-bce
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)
mtime.conffile..etc.mysql.my.cnf: 2014-03-10T11:55:11.697839

Revision history for this message
James Page (james-page) wrote :
Revision history for this message
Morgan Tocker (morgo) wrote :

Just a brief comment from upstream:

Turning off query cache is an acceptable resolution. It is off by default from MySQL 5.6+
http://www.tocker.ca/2013/09/10/improving-mysqls-default-configuration.html

(The query cache mutex is hot on multi-core systems.)

James Page (james-page)
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
James Page (james-page)
Changed in mysql-5.5 (Ubuntu Trusty):
status: New → Triaged
James Page (james-page)
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
Revision history for this message
James Page (james-page) wrote :

Adding a pxc specific config file into /etc/mysql/conf.d is an appropriate work-around for this bug.

James Page (james-page)
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty):
status: In Progress → Fix Committed
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package percona-xtradb-cluster-5.5 - 5.5.34-25.9+dfsg-0ubuntu3

---------------
percona-xtradb-cluster-5.5 (5.5.34-25.9+dfsg-0ubuntu3) trusty; urgency=medium

  * d/p/70_mysql_va_list.patch: Cherry pick patch from mysql-5.5 to ensure that
    va_list usage is portable, fixing FTBFS on armhf and arm64.
 -- James Page <email address hidden> Tue, 11 Mar 2014 15:24:43 +0000

Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty):
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.