# Routine maintenance of mysql DB's **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [December 9, 2006, 11:26pm UTC](https://forums.percona.com/t/routine-maintenance-of-mysql-dbs/142 "2006-12-09T23:26:55Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![carpii](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@carpii](https://forums.percona.com/u/carpii)\ **Post date:** [December 9, 2006, 11:26pm UTC](https://forums.percona.com/t/routine-maintenance-of-mysql-dbs/142/1 "2006-12-09T23:26:55Z")
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 ---
**Author:** ![migandhi](https://avatars.discourse-cdn.com/v4/letter/m/a9a28c/32.png) [@migandhi](https://forums.percona.com/u/migandhi)\ **Post date:** [December 10, 2006, 12:20am UTC](https://forums.percona.com/t/routine-maintenance-of-mysql-dbs/142/2 "2006-12-10T00:20:19Z")
Please check this link for information [URL][http://dev.mysql.com/doc/refman/5.0/en/backup.html[/URL]](http://dev.mysql.com/doc/refman/5.0/en/backup.html%5B/URL%5D) ---
**Author:** ![carpii](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@carpii](https://forums.percona.com/u/carpii)\ **Post date:** [December 11, 2006, 4:45pm UTC](https://forums.percona.com/t/routine-maintenance-of-mysql-dbs/142/3 "2006-12-11T16:45:09Z")
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