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?