Geek Answers Handbook

Search for a lot of constantly updated text in mysql

I have a mysql database where large amounts of text are constantly being added. (10 pages of text per hour). The text is saved as text text in the text box. Each line is associated with a page or two texts.

I need to perform a full-text search (searching for a keyword in the text and performing complex queries) in this database on a regular basis. I just need to find recently added text. But it is very important that the added text be immediately searchable (in a minute or two).

From what I read, the full text with mysql is very inefficient. I know lucene is an option, but I'm still not sure how quickly it can index new text.

So what are my options? is there any way to make mysql more efficient? lucene is my best solution? anything more suitable?

thank

+5
source share
2 answers

I did benchmarking for Times indexing for Sphinx and Solr. Sphinx is far ahead of Solr in terms of indexing algorithms (ultra-fast indexing and small index size).

10 , , Sphinx . + - Sphinx ( Sphinx). . , , , .

Solr , Sphinx rock!! Sphinx.

, Solr/Lucene ( - ), , , Sphinx.

" + " , , , . : Sphinx "" ( ) " + ". , "" "" .

, , 10 , , , . (, 1 ), , 10 . , , table + delta, . , . , -, .

+2

:

. . .

+2

More articles:


All Articles