The following maintenance jobs are typically run against a MySQL database:
- Backup
- Clean-up binary logs
- Optimize tables
- Purge query cache
- Rotate binary logs
Backup
A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements.
