proxysql/etc/logrotate.d/proxysql

/var/lib/proxysql/proxysql.log {
    missingok
    notifempty
    copytruncate
}