# - I put everything in one block and added sharedscripts, so that mysql gets
#   flush-logs'd only once.
#   Else the binary logs would automatically increase by n times every day.
/var/log/mysql-<%= @mysql_instance %>/mysql.log /var/log/mysql-<%= @mysql_instance %>/mysql-slow.log /var/log/mysql-<%= @mysql_instance %>/error.log {
  daily
  rotate 7
  missingok
  create 640 mysql adm
  compress
  sharedscripts
  postrotate
    test -x /usr/bin/mysqladmin || exit 0
    # If this fails, check debian.conf!
    MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql-<%= @mysql_instance %>/logrotator.cnf"
    if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then
      # Really no mysqld or rather a missing debian-sys-maint user?
      # If this occurs and is not a error please report a bug.
      #if ps cax | grep -q mysqld; then
      if killall -q -s0 -umysql mysqld; then
        exit 1
      fi
    else
      $MYADMIN flush-logs
    fi
  endscript
}

# - I put everything in one block and added sharedscripts, so that mysql gets
#   flush-logs'd only once.
#   Else the binary logs would automatically increase by n times every day.
/var/log/mysql-<%= @mysql_instance %>/mysql.log /var/log/mysql-<%= @mysql_instance %>/mysql-slow.log /var/log/mysql-<%= @mysql_instance %>/error.log /var/lib/mysql-<%= @mysql_instance %>/*.log {
  daily
  rotate 7
  missingok
  create 640 mysql adm
  compress
  sharedscripts
  postrotate
    test -x /usr/bin/mysqladmin || exit 0
    # If this fails, check debian.conf!
    MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql-<%= @mysql_instance %>/logrotator.cnf"
    if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then
      # Really no mysqld or rather a missing debian-sys-maint user?
      # If this occurs and is not a error please report a bug.
      #if ps cax | grep -q mysqld; then
      if killall -q -s0 -umysql mysqld; then
        exit 1
      fi
    else
      $MYADMIN flush-logs
    fi
  endscript
}

Add default location for general & slow query logs
Add default location for general & slow query logs

As it turns out, the default location for the slow query log file using the
mysql >= 8.0 cookbook is /var/lib/mysql-#{name}

This adds a catchall for any *.log files at that path, to avoid someone
using this cookbook & thinging they’re all set, then nearly being bitten by
a disk filling up (like me)
