Re: mysql_slow_queries.log flush

[waruna Senavirathna]

you can use linux logrotate for this

1) first you need to configure my.cnf

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

2)
open or create /etc/logrotate.d/mysql file
add this line

/var/lib/mysql/*.log {
# create 600 mysql mysql
notifempty
daily
rotate 3
missingok
compress
postrotate
# just if mysqld is really running
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping &>/dev/null
then
/usr/bin/mysqladmin flush-logs
fi
endscript
}
#

if you are not configured my.cnf
[mysqladmin]
password = <secret>
user= root
you can add replace "/usr/bin/mysqladmin flush-logs" line like below

/usr/bin/mysqladmin -u<mysql user> -p<mysql user password> flush-logs

3)

logrotate -f /etc/logrotate.d/mysql