mysql sphinx来搭建社工库

mysql sphinx来搭建社工库

搭建教程:

先导入sql

下载sphinx  /  我用的是windows版的  当然linux也差不多

创建配置文件sphinx-zh/f

#

# Minimal Sphinx configuration sample (clean, simple, functional)

#

source src1

{

type = mysql

sql_host = localhost

sql_user = root

sql_pass = 1141056911

sql_db = md5

sql_port = 3306

sql_query = SELECT `id`,`username`,`password`,`email`,`salt`,`order` FROM md5_sgk

sql_query_info = SELECT * FROM md5_sgk WHERE id=$id

}

index test1

{

source = src1

path = D:/sphinx-zh/data/

docinfo = extern

charset_type = utf-8

chinese_dictionary = D:/sphinx-zh/etc/xdict

}

indexer

{

mem_limit = 256M

}

searchd

{

listen = 9312

listen = 9306:mysql41

log = D:/sphinx-zh/log/searchd.log

query_log = D:/sphinx-zh/log/query.log

read_timeout = 5

max_children = 30

pid_file = D:/sphinx-zh/searchd.pid

max_matches = 1000

seamless_rotate = 1

preopen_indexes = 1

unlink_old = 1

workers = threads # for RT to work

binlog_path = D:/sphinx-zh/1

}

然后执行命令创建索引 C:Documents and SettingsAdministrator>cd D:sphinx-zhbin

C:Documents and SettingsAdministrator>cd /d D:sphinx-zhbin

D:sphinx-zhbin>indexer --all

sphinx-for-chinese 2.1.0-dev (r3361)

Copyright (c) 2008-2012, sphinx-search

using config file './f'...

indexing index 'test1'...

WARNING: Attribute count is 0: switching to none docinfo

^Cllected 9000 docs, 0.4 MB

现在就开始创建索引了请耐心等待 创建完成以后执行 启动搜索服务

然后就可以用如下源码查询了 sgk源码:

sgk

源码还需要自行改改

接下来就尽情享受毫秒级搜索的速度吧

希望与广大网友互动？？

点此进行留言吧！