linux sphinx官方文件配置问题

linux sphinx官方文件配置问题

全部按照官方的配置文件 索引文件生成成功 前台无法搜索

老大看下是不是系统问题

sphinx.zip

source kms_db
{
	type			= mysql
	sql_host		= localhost
	sql_user		= w11
	sql_pass		= 121111
	sql_db			= w111
	sql_port		= 3306	# optional, default is 3306
	sql_sock		= /tmp/mysql.sock
	sql_query_pre		= SET NAMES utf8
	# sql_query_pre		= SET SESSION query_cache_type=OFF

  sql_query_pre   = SET NAMES utf8


	sql_query		= \
        SELECT ID, TopicID , IsTopic , IF(IsTopic, Subject, '') as Subject, Content,  PostTime \
		FROM carbon_posts \
        WHERE IsDel=0

	sql_attr_uint		= TopicID
    sql_attr_bool       = IsTopic
	sql_attr_timestamp	= PostTime

    sql_ranged_throttle = 500

  sql_query_info		= SELECT * FROM carbon_posts WHERE ID=$id

	
}
index PostsIndexes
{
	source			= kms_db
	path			= /usr/local/sphinx/var/data/PostsIndexes
	docinfo			= extern
    charset_type    = utf-8
    min_word_len    = 1
    charset_table   = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
    ngram_len       = 1
    ngram_chars     = U+3000..U+2FA1F
    html_strip      = 1
}

indexer
{
	mem_limit		= 128M
}
searchd
{
	# [hostname:]port[:protocol], or /unix/socket/path to listen on
	# known protocols are 'sphinx' (SphinxAPI) and 'mysql41' (SphinxQL)
	#
	# multi-value, multiple listen points are allowed
	# optional, defaults are 9312:sphinx and 9306:mysql41, as below
	#
	# listen			= 127.0.0.1
	# listen			= 192.168.0.1:9312
	# listen			= 9312
	# listen			= /var/run/searchd.sock
	listen			= 9312
	listen			= 9306:mysql41
	log			= /usr/local/sphinx/var/log/searchd.log

	query_log		= /usr/local/sphinx/var/log/query.log
	read_timeout		= 5
	client_timeout		= 300
	max_children		= 30

	persistent_connections_limit	= 30
	pid_file		= /usr/local/sphinx/var/log/searchd.pid
	seamless_rotate		= 1
	preopen_indexes		= 1
	unlink_old		= 1
	mva_updates_pool	= 1M
	max_packet_size		= 8M
	max_filters		= 256
	max_filter_values	= 4096
	max_batch_queries	= 32
	workers			= threads # for RT to work
}

@lincanbin

[root@iZj6ca etc]# /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
Sphinx 2.3.2-id64-beta (4409612)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/usr/local/sphinx/etc/sphinx.conf'...
WARNING: key 'sql_query_info' was permanently removed from Sphinx configuration. Refer to documentation for details.
WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details.
indexing index 'PostsIndexes'...
collected 2696 docs, 7.1 MB
sorted 2.3 Mhits, 100.0% done
total 2696 docs, 7118941 bytes
total 0.813 sec, 8753940 bytes/sec, 3315.18 docs/sec
total 4 reads, 0.003 sec, 1626.8 kb/call avg, 0.9 msec/call avg
total 24 writes, 0.010 sec, 565.1 kb/call avg, 0.4 msec/call avg