Routine maintenance of mysql DB's

MySQL & MariaDB Other MySQL® Questions
1

Hi, Im a MSSQL DBA/Developer who uses MySQL for my personal projects. With MSSQL, there are several routine tasks I do just to keep the databases running smoothly (defrag of indices etc, integrity checks etc)

On MySQL I use innodb, and my database is now growing to a non trivial size (130GB). What routines should I be running regularly ?

Maybe ANALYSE/OPTIMISE table?
Any other you can suggest please?

Thanks

2

Please check this link for information
[URL]http://dev.mysql.com/doc/refman/5.0/en/backup.html[/URL]

3

Hi, thanks for the advice, but I dont have any issues with backups

Im mainly interested in any maintenance tasks I should run, maybe tables and indices get fragmented, and should be defragged occasionally