MariaDB mysql-server configuration example for Ubuntu 18.04 LTS (Bionic Beaver)

Get the default configuration file mysql-server for MariaDB, optimized for Ubuntu 18.04 LTS (Bionic Beaver). This example configuration ensures optimal compatibility and performance for MariaDB, 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/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
Ubuntu 18.04 LTS (Bionic Beaver)
Length
20 lines
MD5 checksum
3b27c6ac3dbfe31c1c1db0f880b3a2f4

Usage

Download the raw file with wget or curl

Wget

wget -O mysql-server.example https://exampleconfig.com/static/raw/mariadb/ubuntu18.04/etc/logrotate.d/mysql-server

cURL

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