Hi Steve What does your define_index block for Business look like?
-- Pat On 14/12/2009, at 1:44 PM, Steve H wrote: > 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. > > -- 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.
