I used just:
yum install sphinx
#edit config
source src_torrnado
{type = mysql
sql_host = 127.0.0.1 #37.58.58.234
sql_user = APP_NAME
sql_pass = PASS
sql_db = APP_NAME
sql_port = 3306 # optional, default is 3306
sql_query_pre = SET NAMES utf8
sql_query = SELECT `id`,`categoryId`,`comment`, `tags`, `name`,`hash` FROM `results`;
sql_field_string = comment
sql_field_string = tags
sql_field_string = name
sql_field_string = hash
sql_attr_uint = categoryId
sql_query_info = SELECT * FROM results WHERE id=$id
}
index ix_torrnado
{
# type = rt
source = src_APP_NAME
path = /etc/sphinx/APP_NAME/src_APP_NAME
docinfo = extern
charset_type = utf-8
# charset_type = sbcs
morphology = stem_enru
enable_star = 1
min_prefix_len = 2
expand_keywords = 1
html_strip = 1
rt_mem_limit = 4G
}
indexer
{
mem_limit = 128M
}
searchd
{
listen = 9312
listen = 9306:mysql41
log = /etc/sphinx/logs/APP_NAME-searchd.log
query_log = /etc/sphinx/logs/APP_NAME-query.log
pid_file = /run/sphinx/searchd.pid
read_timeout = 5
max_children = 30
max_matches = 1000
workers = threads # for RT to work
thread_stack = 1M
binlog_path = /etc/sphinx/logs
}
#creare dirs in /etc/sphinx/ for logs and index and ser perm:
mkdir /etc/sphinx/APP_NAME
mkdir /etc/sphinx/logs
chown -R sphinx:sphinx /etc/sphinx/APP_NAME
chown -R sphinx:sphinx /etc/sphinx/logs
chmod -R 0755 /etc/sphinx/APP_NAME
chmod -R 0755 /etc/sphinx/logs
service searchd start
sudo chkconfig --levels 235 searchd
on
No comments:
Post a Comment