OK first off -- I'm not 100% certain that 1 doc = 1 record. But if it DOES then, sphinx definitely didn't collect enough. We have over 13 million rows in our database, but this was the output after indexing:
----------------------------------------------- indexing index 'business_core'... collected 1199 docs, 0.7 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.1 Mhits, 100.0% done total 1199 docs, 685923 bytes total 1381.345 sec, 496.56 bytes/sec, 0.87 docs/sec distributed index 'business' can not be directly indexed; skipping. Started successfully (pid 32011). ----------------------------------------------- After reading some of the docs, I thought... maybe I have to increase the sql_range_step in the sphinx.yml or increase the group_concat_max_len property. So I did those things, but the output after indexing is the same (albeit much much faster :) ----------------------------------------------- Stopped search daemon (pid 2810). Generating Configuration to /home/steve/insiderpages/config/ sphinx_dev.sphinx.conf Sphinx 0.9.8.1-release (r1533) Copyright (c) 2001-2008, Andrew Aksyonoff using config file '/home/steve/insiderpages/config/ sphinx_dev.sphinx.conf'... indexing index 'business_core'... collected 1199 docs, 0.1 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 1199 docs, 79605 bytes total 0.447 sec, 177901.38 bytes/sec, 2679.53 docs/sec distributed index 'business' can not be directly indexed; skipping. Started successfully (pid 6365). ----------------------------------------------- What's the problem? -Steve PS: mysql> select count(id) from businesses; +-----------+ | count(id) | +-----------+ | 13395683 | +-----------+ 1 row in set (0.00 sec) mysql> select max(id) from businesses; +-------------+ | max(id) | +-------------+ | 15250646126 | +-------------+ 1 row in set (0.00 sec) -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
