MySQL mysql-server configuration example for Ubuntu 16.04 LTS (Xenial Xerus)

Get the default configuration file mysql-server for MySQL, optimized for Ubuntu 16.04 LTS (Xenial Xerus). This example configuration ensures optimal compatibility and performance for MySQL, making it easy to set up and adjust to meet your needs.

Find and download the configuration file here: /etc/logrotate.d/mysql-server.

For more configurations and setup guides, visit our related files section to further customize your system.

    # - 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 https://exampleconfig.com/static/raw/mysql/ubuntu16.04/etc/logrotate.d/mysql-server

cURL

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