How much extra space / RAM / CPU does apache solr use?

I am using a MySQL database for my webapp. I need to search for multiple tables and multiple columns, this is very similar to a full-text search inside these columns.

I need to know your experience using any full text search API (e.g. solr / lucene / mapReduce / hadoop, etc.) using plain SQL in terms of:

  • Speed ​​performance
  • Using extra space
  • Additional CPU usage (is it constantly building an index?)
  • How long does it take to create an index or is it ready to use?
  • Please let me know your experience using these frameworks.

Thank you so much!

+5
source share
2

1.) 5 . MySQL Fulltextsearch 2-3 . Solr/Lucene 200-400 .

2.) , . , . Solr/Lucene 30 40 . , () , 100% .

3.) MySQL fulltext-Index Lucene/Solr, CPU Power. MySQL Fulltext , Solr → 1.)

4.) , . , . . 2 , 8 . 5 (44 ) 2-3 VMware.

5.) MySQL Fulltext-Index Lucene/Solr. Fulltextindex -.;-) , , .

// : " Lucene Insert"

SOlR,

+8

Q1: Lucene ( )

Q2: , 20-30% ()

Q4: , , , ( ..), ... . 15 500 (- , ), 3 , 17 .

+3

All Articles