#
# Log rotation rules for Noggin's mysql configuration
#

/var/log/mysql/mysqld.log {
        # create 600 mysql mysql
        su mysql mysql
        notifempty
        missingok
        sharedscripts
        postrotate
            # just if mysqld is really running
            if test -x /usr/bin/mysqladmin && \
               test -x /usr/bin/mysql && \
               /usr/bin/mysqladmin ping &>/dev/null
            then
               /usr/bin/mysql -e 'FLUSH ERROR LOGS' &>/dev/null
            fi
            # We might be writing the logs though a filter....
            if /usr/bin/systemctl --quiet is-active mysqld-log-filter.service; then
               /usr/bin/systemctl reload mysqld-log-filter.service
            fi
        endscript
}

/var/log/mysql/slow-query.log {
        # create 600 mysql mysql
        su mysql mysql
        notifempty
        missingok
        sharedscripts
        postrotate
            # just if mysqld is really running
            if test -x /usr/bin/mysqladmin && \
               test -x /usr/bin/mysql && \
               /usr/bin/mysqladmin ping &>/dev/null
            then
               /usr/bin/mysql -e 'FLUSH SLOW LOGS' &>/dev/null
            fi
        endscript
}

