I've about 40 databases with similar schema. So what can I to ensure these databases run easily?
Must I be optimizing tables regularly? How do i identify table crashes?
As referred to at length inside the below article, the minimum actions you need to perform include,
- database backup
- check table integrity for errors
- optimize tables (varies between MyISAM and InnoDB)