/var/lib/mysql/*.err {
        # create 600 mysql mysql
        notifempty
        maxsize 1G
        weekly
        rotate 8
        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
}