This is the default example configuration of mysql-server provided by MariaDB. This config file was generated by MariaDB running on Ubuntu 20.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/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 http://exampleconfig.com/static/raw/mariadb/ubuntu20.04/etc/logrotate.d/mysql-server
curl http://exampleconfig.com/static/raw/mariadb/ubuntu20.04/etc/logrotate.d/mysql-server > mysql-server.example
Other config files you might find useful