开发者

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/

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜