开发者

MyISAM for logging and export?

开发者 https://www.devze.com 2023-02-03 13:34 出处:网络
in \"High Performance MySQL\" from o\'Reilly I\'ve read, that MyISAM could be a good alternativ开发者_开发知识库e to InnoDB for logging situations.

in "High Performance MySQL" from o'Reilly I've read, that MyISAM could be a good alternativ开发者_开发知识库e to InnoDB for logging situations. So we've a high rate of INSERTs on some tables, so MyISAM can be used, but there is also an export of old data every 3 minutes (so the table is dumped and flushed every 3 minutes and the data is transferred to another server). Has anyone experience in such a situation? Could MyISAM really be a good choice to InnoDB (which we are currently using)? Regards


Use replication, dump on slave, and flush the master daily.

0

精彩评论

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