mysql charm timeout_wait is high
Bug #1386791 reported by
Jill Rouleau
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
lp:~jjo/charm-helpers/add-wait-timeout
- Jorge Niedbalski (community): Approve
-
Diff: 13 lines (+3/-0)1 file modifiedcharmhelpers/contrib/database/mysql.py (+3/-0)
lp:~jjo/charms/trusty/mysql/add-wait-timeout
- Jorge Niedbalski (community): Approve
-
Diff: 42 lines (+12/-1)2 files modifiedconfig.yaml (+4/-0)
hooks/config-changed (+8/-1)
lp:~jjo/charms/trusty/percona-cluster/add-wait-timeout
- OpenStack Charmers: Pending requested
-
Diff: 59 lines (+12/-2)3 files modifiedconfig.yaml (+4/-0)
hooks/charmhelpers/contrib/database/mysql.py (+3/-2)
templates/my.cnf (+5/-0)
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 |
Changed in percona-cluster (Juju Charms Collection): | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
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: /bugs.launchpad .net/bugs/ 1386791 /bugs.launchpad .net/charms/ +source/ mysql/+ bug/ +subscriptions
>
> 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:/
>
> 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:/
> 1386791/
>