mysql charm timeout_wait is high

Bug #1386791 reported by Jill Rouleau
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
mysql (Juju Charms Collection)
Fix Released
Medium
JuanJo Ciarlante
percona-cluster (Juju Charms Collection)
Fix Released
Medium
JuanJo Ciarlante

Bug Description

The default setting for timeout_wait is using the server default of 28800. This is excessive for a typical application and allows badly behaving apps to abuse the database with abandoned connections.

Please evaluate reducing this setting or making this a user-configurable setting in the charm.

Related branches

Revision history for this message
Marco Ceppi (marcoceppi) wrote : Re: [Bug 1386791] [NEW] mysql charm timeout_wait is high

What would you recommend for a more sane default?

On Tue, Oct 28, 2014, 1:00 PM Jill Rouleau <email address hidden>
wrote:

> Public bug reported:
>
> The default setting for timeout_wait is using the server default of
> 28800. This is excessive for a typical application and allows badly
> behaving apps to abuse the database with abandoned connections.
>
> Please evaluate reducing this setting or making this a user-configurable
> setting in the charm.
>
> ** Affects: mysql (Juju Charms Collection)
> Importance: Undecided
> Status: New
>
>
> ** Tags: canonical-bootstack
>
> --
> You received this bug notification because you are subscribed to mysql
> in Juju Charms Collection.
> Matching subscriptions: MySQL-Charm
> https://bugs.launchpad.net/bugs/1386791
>
> Title:
> mysql charm timeout_wait is high
>
> Status in “mysql” package in Juju Charms Collection:
> New
>
> Bug description:
> The default setting for timeout_wait is using the server default of
> 28800. This is excessive for a typical application and allows badly
> behaving apps to abuse the database with abandoned connections.
>
> Please evaluate reducing this setting or making this a user-
> configurable setting in the charm.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/charms/+source/mysql/+bug/
> 1386791/+subscriptions
>

Revision history for this message
Jill Rouleau (jillrouleau) wrote :

1800-3600 should be sane for a large majority of cases. I'd err on the side of 3600 for a default.

Changed in mysql (Juju Charms Collection):
assignee: nobody → JuanJo Ciarlante (jjo)
Changed in percona-cluster (Juju Charms Collection):
assignee: nobody → JuanJo Ciarlante (jjo)
Changed in mysql (Juju Charms Collection):
status: New → In Progress
Changed in percona-cluster (Juju Charms Collection):
status: New → In Progress
Changed in mysql (Juju Charms Collection):
importance: Undecided → Medium
Changed in percona-cluster (Juju Charms Collection):
importance: Undecided → Medium
Changed in percona-cluster (Juju Charms Collection):
status: In Progress → Fix Committed
Changed in mysql (Juju Charms Collection):
status: In Progress → Won't Fix
status: Won't Fix → Fix Released
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.