MyISAM的写入速度？
我有一个大表，我想要进行全文搜索，所以我将其设为MyISAM，因为InnoDB不支持它。
如果我向该表写入大量内容，是否会出现性能问题？有人告诉我 MyISAM 在写入期间锁定整个表。
如果我同时需要全文搜索和非锁定写入，还有其他选择吗？
I have this big table which I want to have fulltext search, so I made it MyISAM, as InnoDB doesn't support that.
Am I gonna have performance issues if I write a lot to that table? I have been told that MyISAM locks the whole table during writes.
Do I have any other option if I need both fulltext search and non-locking write?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您向 MyISAM 表写入大量数据，您最终会遇到 InnoDB 不会出现的锁定问题。我建议研究全文搜索的其他选项，例如 Lucene 或 Solr
现在可以通过多种语言访问它们。请参阅 Lucene 教程 开始使用。
If you write a lot to a MyISAM table you'll eventually have locking issues that you wouldn't with InnoDB. I recommend looking into other options for full-text search, e.g. Lucene or Solr
that are both accessible from a number of languages now. See Lucene Tutorial to get started.
如果您对第 3 方解决方案（适用于您的 MySQL 数据库）感到满意，我强烈建议使用 Sphinx 来处理您的全文搜索。正如您在他们的网站上看到的，它得到了社区的高度认可，并且在应用程序级别交互方面得到了大力支持。
当然，除了 Sphinx 之外，还有其他解决方案，您可以在其中看到一个精彩的 SO 讨论，对它们进行比较：
选择独立的全文搜索服务器：Sphinx 还是 SOLR？
If you are OK with 3rd party solutions(that work with your MySQL database), I'd highly suggest Sphinx to handle your fulltext search. As you can see on their website, it is highly endorsed by the community and very supported in terms of application level interaction.
There are of course other solutions other than Sphinx, in which you can see a fantastic SO discussion comparing them here:
Choosing a stand-alone full-text search server: Sphinx or SOLR?