/etc/logrotate.d/mysql-server - Debian GNU/Linux 9 (stretch)

This is the default example configuration of mysql-server provided by MariaDB. This config file was generated by MariaDB running on Debian 9.

It is located under: /etc/logrotate.d/mysql-server

    # - 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.
# - The error log is obsolete, messages go to syslog now.
/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log {
	daily
	rotate 7
	missingok
	create 640 mysql adm
	compress
	sharedscripts
	postrotate
          test -x /usr/bin/mysqladmin || exit 0
          if [ -f `my_print_defaults --mysqld | grep -m 1 -oP "pid-file=\K.+$"` ]; then
            # If this fails, check debian.conf!
            mysqladmin --defaults-file=/etc/mysql/debian.cnf --local flush-error-log \
              flush-engine-log flush-general-log flush-slow-log
          fi
	endscript
}

    
  

Config Details

Location
/etc/logrotate.d/mysql-server
Operating system
Debian GNU/Linux 9 (stretch)
Length
20 lines
MD5 checksum
3b27c6ac3dbfe31c1c1db0f880b3a2f4

Usage

Download the raw file with wget or curl

Wget

wget -O mysql-server.example http://exampleconfig.com/static/raw/mariadb/debian9/etc/logrotate.d/mysql-server

cURL

curl http://exampleconfig.com/static/raw/mariadb/debian9/etc/logrotate.d/mysql-server > mysql-server.example