On Mon, Jul 14, 2008 at 9:52 AM, Fuad Efendi <[EMAIL PROTECTED]> wrote: > Even Oracle requires 65536; MySQL+MyISAM depends on number of tables, > indexes, and Client Threads. > > From my experience with Lucene, 8192 is not enough; leave space for OS too. > > Multithreaded application (in most cases) multiplies number of files to a > number of threads (each thread needs own handler), in case with SOLR-Tomcat: > 256 threads... Number of files depends on mergeFactor=10 (default for SOLR). > Now, if 10 is "merge factor" and we have *.cfs, *.fdt, etc (6 file types per > segment): > 256*10*6 = 15360 (theoretically)
In Solr, the number of threads does not come into play. It would only matter in Lucene if you were doing something like opening an IndexReader per thread or something. The number of files per segment is normally more like 12, but only 9 of them are held open for the entire life of the reader. Also remember that the IndexWriter internally uses another IndexReader to do deletions, and Solr can have 2 (or more) open... one serving queries and one opening+warming. -Yonik