This is just meant to be a simple list of cron jobs that I’ve used to maintain my Ubuntu MySQL/MariaDB database … nothing fancy. They go into sudo crontab -e:
9 * * * * mysql -u root -p[PUT YOUR ROOT DB PASSWORD HERE] -e "PURGE BINARY LOGS BEFORE (NOW() - INTERVAL 18 HOUR);" 8 * * * * mysqlcheck -Ao --auto-repair -u root -p[PUT YOUR ROOT DB PASSWORD HERE]
The first cronjob runs at 9:00 am every day and will remove any BINLOGs from /var/lib/mysql that are older than 18 hours. These logs can grow fast, but this should keep them tidy.
The second cronjob runs at 8:00 am every day and does an autorepair of all databases.
Remember to replace the entire [PUT YOUR ROOT DB PASSWORD HERE] line, even the square brackets. There should be no spaces between -p and your password. This is in root’s crontab so it should be safe from snoopers.