General Mysql database maintenance advice

I have about 40 databases with the same schema. What can I so to ensure these databases run smoothly?

Should I be optimizing tables regularl开发者_如何学Cy? How can I detect table crashes?

---

As described in detail within the below article, the bare minimum actions you should perform include,

1. database backup
2. check table integrity for errors
3. optimize tables (varies between MyISAM and InnoDB)
4. analyze

http://www.laurencegellert.com/2011/07/mysql-maintenance-tasks-for-innodb-with-mysql-5-1/