/var/log/mysqld.log {
        create 640 mysql root
        notifempty
        daily
        rotate 5
        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 --defaults-extra-file=/root/.my.cnf flush-logs
    fi
      endscript
}