Добрый день. Есть вот такая таблица 320.000 строк, 11гиг весит сделал такой конфиг файл для sphinx Код | source lostdiplom_source { type = mysql
sql_host = **** sql_user = **** sql_pass = **** sql_db = **** sql_port = 3306 # optional, default is 3306
sql_query_pre = SET NAMES utf8 sql_query_pre = SET CHARACTER SET utf8
sql_query = \ SELECT `title`,`description`,`type_title`,`category_title` \ FROM `search`
sql_ranged_throttle = 0
sql_query_info = SELECT * FROM `search` WHERE ID = $id
sql_range_step = 1000000 }
index lostdiplom_index { source = lostdiplom_source
path = /var/lib/sphinxsearch/data/lostdiplom
docinfo = extern
mlock = 0
morphology = stem_ru, soundex, metaphone
min_word_len = 3
charset_type = utf-8
html_strip = 1 }
indexer { mem_limit = 1024M }
searchd { log = /var/log/sphinxsearch/searchd.log
query_log = /var/log/sphinxsearch/query.log
read_timeout = 5
client_timeout = 300
max_children = 30
pid_file = /var/run/searchd.pid
max_matches = 10000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
mva_updates_pool = 1M
max_packet_size = 8M
max_filters = 256
max_filter_values = 4096 }
|
запуска на интдексацию Код | # indexer --config /etc/sphinxsearch/sphinx.conf --rotate --all Sphinx 0.9.9-release (r2117) Copyright (c) 2001-2009, Andrew Aksyonoff
using config file '/etc/sphinxsearch/sphinx.conf'... indexing index 'lostdiplom_index'... WARNING: zero/NULL document_id, skipping collected 1004 docs, 10.9 MB sorted 0.7 Mhits, 97.9% done total 1004 docs, 10880308 bytes total 85.739 sec, 126899 bytes/sec, 11.70 docs/sec total 1 reads, 0.000 sec, 1485.1 kb/call avg, 0.3 msec/call avg total 7 writes, 0.001 sec, 523.3 kb/call avg, 0.2 msec/call avg rotating indices: succesfully sent SIGHUP to searchd (pid=10329).
|
индексирует только 1000 дукументов из 320.000. При поиске ничего не возвращает. В чем ошибка? Это сообщение отредактировал(а) Fubu_By - 27.11.2014, 11:35
|