mysql sphinx来搭建 工库_代码区软件项目交易 ,CodeSection,代码区,分享我的 工库的裤子+sphinx 工库搭建教程…

搭建教程:

先导入md5.phpinfo.me.sql

下载sphinx http://sphinxsearch.com/ 我用的是windows版的 当然linux也差不多

创建配置文件sphinx-zh/bin/sphinx.conf#

# 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.comusing config file ‘./sphinx.conf’…

indexing index ‘test1’…

WARNING: Attribute count is 0: switching to none docinfo

^Cllected 9000 docs, 0.4 MB

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

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

sgk

源码还需要自行改改

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

文章知识点与官方知识档案匹配，可进一步学习相关知识MySQL入门技能树首页概览31984 人正在系统学习中 相关资源：用PS软件给别人腿部增加丝袜裤–HP其他资源-CSDN文库