mysql charm max connection limit is low

Bug #1382386 reported by Brad Marshall
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
mysql (Juju Charms Collection)
Confirmed
High
Unassigned
percona-cluster (Juju Charms Collection)
Fix Released
High
James Page

Bug Description

The default limits for the max number of connections is currently set to the server default, which is 151.

This is quite low for any reasonable web application, and it seems worthwhile upping this in the charm, as the overhead of extra connections isn't that high these days.

Please look at increasing the max connection limits, or at least having some warning about how this may be low.

Revision history for this message
Jason Hobbs (jason-hobbs) wrote :

I agree - this is too low. We ran out of connections quite a bit in OIL until doubling the setting to 300 connections. I think this should be bumped higher by default.

Marco Ceppi (marcoceppi)
Changed in mysql (Juju Charms Collection):
status: New → Confirmed
importance: Undecided → High
James Page (james-page)
Changed in percona-cluster (Juju Charms Collection):
status: New → Triaged
importance: Undecided → High
tags: added: bite-sized
James Page (james-page)
Changed in percona-cluster (Juju Charms Collection):
milestone: none → 16.10
James Page (james-page)
Changed in percona-cluster (Juju Charms Collection):
status: Triaged → In Progress
assignee: nobody → James Page (james-page)
Revision history for this message
James Page (james-page) wrote :
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to charm-percona-cluster (master)

Reviewed: https://review.openstack.org/374617
Committed: https://git.openstack.org/cgit/openstack/charm-percona-cluster/commit/?id=14a093684a4920b1db8259a377d1b227137ccc7c
Submitter: Jenkins
Branch: master

commit 14a093684a4920b1db8259a377d1b227137ccc7c
Author: James Page <email address hidden>
Date: Thu Sep 22 09:36:40 2016 +0100

    Increase default max-connections

    The server compiled default of 151 is not very useful in anything
    other than a single client deployment; increased the default
    max-connections value to 600, which is much more useful.

    Change-Id: I3e8c0fcc3e85ccf1990af77610401ebbd257b549
    Closes-Bug: 1382386

Changed in percona-cluster (Juju Charms Collection):
status: In Progress → Fix Committed
James Page (james-page)
Changed in percona-cluster (Juju Charms Collection):
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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