Implement cron job which runs logrotate on 03:02 AM everyday.
If the size of any of the log files in /var/lib/mysql/ goes above 1GB, it makes a copy of that file and empties the main log file. That copy is deleted and a new copy made when the main file goes over 1GB again.
Implement cron job which runs
logrotateon 03:02 AM everyday. If the size of any of the log files in/var/lib/mysql/goes above 1GB, it makes a copy of that file and empties the main log file. That copy is deleted and a new copy made when the main file goes over 1GB again.