Chris Muench
Chris Muench

Reputation: 18328

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 regularly? How can I detect table crashes?

Upvotes: 16

Views: 31235

Answers (1)

Dennis
Dennis

Reputation: 4017

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/

Upvotes: 19

Related Questions