Create one single unified and optimal logrotate config

$ cat support-files/mysql-log-rotate.sh 

# This logname can be set in /etc/my.cnf

# by setting the variable "log-error"

# in the [mysqld] section as follows:

#

# [mysqld]

# log-error=@localstatedir@/mysqld.log

#

# If the root user has a password you have to create a

# /root/.my.cnf configuration file with the following

# content:

#

# [mysqladmin]

# password = <secret> 

# user= root

#

# where "<secret>" is the password. 

#

# ATTENTION: This /root/.my.cnf should be readable ONLY

# for root !

@localstatedir@/mysqld.log {

        # create 600 mysql mysql

        notifempty

        daily

        rotate 3

        missingok

        compress

    postrotate

	# just if mysqld is really running

	if test -x @bindir@/mysqladmin && \

	   @bindir@/mysqladmin ping &>/dev/null

	then

	   @bindir@/mysqladmin --local flush-error-log \

              flush-engine-log flush-general-log flush-slow-log

	fi

    endscript

}

$ cat debian/mariadb-server-10.5.mysql-server.logrotate 

# - 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 -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

}