/etc/logrotate.d/mysql-server - Ubuntu 16.04 LTS (Xenial Xerus)

This is the default example configuration of mysql-server provided by MySQL. This config file was generated by MySQL running on Ubuntu 16.04.

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.log /var/log/mysql/*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/debian.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
}

    
  

Config Details

Location
/etc/logrotate.d/mysql-server
Operating system
Ubuntu 16.04 LTS (Xenial Xerus)
Length
27 lines
MD5 checksum
b3c32cbc55b042b1fe76698c8e928974

Usage

Download the raw file with wget or curl

Wget

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

cURL

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