MySQL InnoDB文本搜索选项 [英] MySQL InnoDB Text Search Options

问题描述

充分了解我的InnoDB表不支持FULLTEXT搜索，我想知道我的替代选择是用于在表格中搜索文本吗？使用LIKE时性能 不好？

我看到很多建议说要在MYISAM表中创建有问题的InnoDB表副本，然后针对THAT表运行查询并在两者之间匹配键我只是不知道这是一个很好的解决方案。

我并不反对使用第三方解决方案，但我并不是那么喜欢。我想更多地探讨MySQL可以自己做什么。

想法？

解决方案

它正确你可能应该使用 Lucene 或< a href =http://sphinxsearch.com/ =nofollow>狮身人面像从一开始。

1. 它可以让你保留你的表格结构。


2. 你将获得巨大的性能提升将可以访问许多奇特的搜索功能

Lucene和Sphinx的缩放比例非常好（Lucene支持维基百科和Digg / Sphinx的功能Slashdot）

Knowing full well that my InnoDB tables don't support FULLTEXT searches, I'm wondering what my alternatives are for searching text in tables ? Is the performance that bad when using LIKE ?

I see a lot of suggestions saying to make a copy of the InnoDB table in question in a MYISAM table, and then run queries against THAT table and match keys between the two and I just don't know that that's a pretty solution.

I'm not opposed to using some 3rd party solution, I'm not a huge fan of that though. I'd like to explore more of what MySQL can do on its own.

Thoughts ?

解决方案

If you want to do it right you probably should go with Lucene or Sphinx from the very start.

1. it will allow you to keep your table structure.
2. you'll have a huge performance boost (think ahead)
3. you'll get access to a lot of fancy search functions

Both Lucene and Sphinx scale amazingly well (Lucene powers Wikipedia and Digg / Sphinx powers Slashdot)

这篇关于MySQL InnoDB文本搜索选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！