Mysql全文索引限制？ [英] Mysql full text indexing limitations?

问题描述

什么是限制或陷阱或反模式或陷阱？

它看起来非常有吸引力，显然你可以创建几乎没有工作的搜索引擎。但它不能没有它的问题......

你有什么经验？

解决方案在我看来，最大的缺点是MySQL全文索引仅限于MyISAM表。与InnoDB表格相反，这些表格缺少很多重要的功能，例如交易。

What are the limitations or gotchas or antipatterns or pitfalls?

It seems pretty attractive, apparently you can create a search engine with almost no work. But it cannot be without its problems...

what are your experiences?

解决方案

In my opinion, the greatest drawback is that the MySQL full text indexing is limited to MyISAM tables. As oppsosed to InnoDB tables, those lack a lot of important features, e.g. transactions.

这篇关于Mysql全文索引限制？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！