加快只读MyISAM表的速度 [英] Speed-up of readonly MyISAM table

问题描述

我们有一个很大的MyISAM表，该表用于存档旧数据.归档每月进行一次，除非从这些情况开始，否则永远不会将数据写入表中.无论如何告诉" MySQL该表是只读的，以便MySQL可以优化从该表读取的性能?我看过MEMORY存储引擎，但问题在于此表太大，以至于会占用服务器内存的很大一部分，这是我不想要的.

We have a large MyISAM table that is used to archive old data. This archiving is performed every month, and except from these occasions data is never written to the table. Is there anyway to "tell" MySQL that this table is read-only, so that MySQL might optimize the performance of reads from this table? I've looked at the MEMORY storage engine, but the problem is that this table is so large that it would take a large portion of the servers memory, which I don't want.

希望我的问题很清楚，关于数据库管理我是新手，所以欢迎大家提出任何意见或建议.

Hope my question is clear enough, I'm a novice when it comes to db administration so any input or suggestions are welcome.

推荐答案

是的，您可以压缩myisam表.

Yes, you can compress the myisam tables.

这是来自5.0的文档: http://dev. mysql.com/doc/refman/5.0/en/myisampack.html

Here is the doc from 5.0 : http://dev.mysql.com/doc/refman/5.0/en/myisampack.html

这篇关于加快只读MyISAM表的速度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！