All geek questions in one place

MySQL InnoDB Text Search Options

Knowing that my InnoDB tables do not support FULLTEXT lookups, I wonder what my alternatives are for looking up text in tables? Is performance so bad when using LIKE?

I see a lot of suggestions about making a copy of the InnoDB table in question in the MYISAM table, and then running queries against the THAT table and matching the keys between them, and I just don't know that this is a pretty acceptable solution.

I am not against using any third-party solution, but I am not a big fan of this. I would like to know more about what MySQL can do on its own.

Thoughts?

+3
source share
3

, , , Lucene Sphinx .

  • .
  • ( )

Lucene, Sphinx (Lucene powers Wikipedia Digg/Sphinx power Slashdot)

+3

LIKE , %. , LIKE '% foo%' . , sphinx. , MySQL, . .

solr, http lucene, sphinx .

+1

, , Lucene, Sphinx Solr.

, , , .

Symfony/PHP, , , . , , , , .

, , , , DAL, fk , . , , .

0

Source: https://habr.com/ru/post/1772028/

More articles:


All Articles