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
}
Download the raw file with wget or curl
wget -O mysql-server.example https://exampleconfig.com/static/raw/mariadb/ubuntu18.04/etc/logrotate.d/mysql-server
curl https://exampleconfig.com/static/raw/mariadb/ubuntu18.04/etc/logrotate.d/mysql-server > mysql-server.example
Other config files you might find useful