slow_query_log should be off by default and relocated

[Bjoern]

The slow query log is currently located at /var/log/mysql/mysql-slow.log and is not covered by logrotate.
I would suggest that we turn it off by default and relocate the logfile to /var/lib/mysql/mysql-slow.log which is bind mounted and contains more disk space than the container root.

[Jesse Pretorius (jesse-pretorius)]

juno's log location is /var/log/mysql/mysql-slow.log
kilo/master's log location is /var/log/mysql_logs/mysql-slow.log

we should allow the slow log to be enabled/disabled by the deployer instead of hard setting it in the template

[Jesse Pretorius (jesse-pretorius)]

log rotation should also be fixed

[Jimmy McCrory (jimmy-mccrory)]

Related, but not sure if this should be a separate bug, log-queries-not-using-indexes is also on by default and seems to be the cause of mysql-slow.log growing so large.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/200274

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/200274
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=70edf52fcd99335bd272d08ded745dec05148215
Submitter: Jenkins
Branch: master

commit 70edf52fcd99335bd272d08ded745dec05148215
Author: Dave Wilde <email address hidden>
Date: Thu Jul 9 14:22:42 2015 -0700

    Parameterize galera slow/unindexed logging options

    This change creates variables for Galera slow logging and logging
    of unindexed queries. The change also defaults these variables to
    off.

    DocImpact
    Closes-Bug: #1463956

    Change-Id: I5f786e2090c631627f3b44ada2baf05fd9699b97

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/200728
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=d4d7c7256b685760f6573cf054dbb31e2e59a3d5
Submitter: Jenkins
Branch: kilo

commit d4d7c7256b685760f6573cf054dbb31e2e59a3d5
Author: Dave Wilde <email address hidden>
Date: Thu Jul 9 14:22:42 2015 -0700

    Parameterize galera slow/unindexed logging options

    This change creates variables for Galera slow logging and logging
    of unindexed queries. The change also defaults these variables to
    off.

    DocImpact
    Closes-Bug: #1463956
    (cherry-picked from: I5f786e2090c631627f3b44ada2baf05fd9699b97)

    Change-Id: I5f786e2090c631627f3b44ada2baf05fd9699b97

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/201625
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=c028a2eb6d28f1c1102b84252167121a12a9b87e
Submitter: Jenkins
Branch: juno

commit c028a2eb6d28f1c1102b84252167121a12a9b87e
Author: Nolan Brubaker <email address hidden>
Date: Tue Jul 14 11:16:46 2015 -0400

    Parameterize galera slow/unindexed logging options

    This change creates variables for Galera slow logging and logging
    of unindexed queries. The change also defaults these variables to
    off.

    Manual backport from master due to differing directory layout.
    DocImpact
    Closes-Bug: #1463956

    Change-Id: I5f786e2090c631627f3b44ada2baf05fd9699b97

[Davanum Srinivas (DIMS) (dims-v)]

This issue was fixed in the openstack/openstack-ansible 11.2.11 release.

[Doug Hellmann (doug-hellmann)]

This issue was fixed in the openstack/openstack-ansible 11.2.12 release.

[Davanum Srinivas (DIMS) (dims-v)]

This issue was fixed in the openstack/openstack-ansible 11.2.14 release.