4,357,045 th visitor since 2017.2.1 ( Today : 623 )
Programming
No. 807
Name. swindler
Subject. Sphinx 설치 2.x 버전
Main Cate. Java
Sub Cate.
Date. 2019-05-21 18:05
Hit. 1542 (211.192.242.143)
File.
개발서버 CentOS 버전이 낮아서 sphinx 3.x 버전을 설치할 수가 없어서
2.3.2.1 을 설치했다.

http://sphinxsearch.com/downloads/archive/


rpm 버전이라 특별히 작업할 것이 없다.

rpm -ivh sphinx-2.3.2-1.rhel5.i386.rpm


설정파일
/etc/sphinx/sphinx.conf

내용을 아래와 같이 작성함.

source sph_VIDEO
{
type = mysql

sql_host = localhost
sql_user = root
sql_pass =
sql_db = lab
sql_port = 3306 # optional, default is 3306

sql_query_pre = SET NAMES utf8

sql_query = SELECT SEQ, ID VID, TITLE, TAG, HASH_TAG FROM VIDEO

sql_field_string = VID
sql_field_string = TITLE
sql_field_string = TAG
sql_field_string = HASH_TAG

}


index sph_VIDEO
{
source = sph_VIDEO
path = /var/lib/sphinx/sph_VIDEO
docinfo = extern
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
min_infix_len = 2

ngram_chars = U+4E00..U+9FBB, U+3400..U+4DB5, U+20000..U+2A6D6, U+FA0E, U+FA0F, U+FA11, U+FA13, U+FA14, U+FA1F, U+FA21, U+FA23, U+FA24, U+FA27, U+FA28, U+FA29, U+3105..U+312C, U+31A0..U+31B7, U+3041, U+3043, U+3045, U+3047, U+3049, U+304B, U+304D, U+304F, U+3051, U+3053, U+3055, U+3057, U+3059, U+305B, U+305D, U+305F, U+3061, U+3063, U+3066, U+3068, U+306A..U+306F, U+3072, U+3075, U+3078, U+307B, U+307E..U+3083, U+3085, U+3087, U+3089..U+308E, U+3090..U+3093, U+30A1, U+30A3, U+30A5, U+30A7, U+30A9, U+30AD, U+30AF, U+30B3, U+30B5, U+30BB, U+30BD, U+30BF, U+30C1, U+30C3, U+30C4, U+30C6, U+30CA, U+30CB, U+30CD, U+30CE, U+30DE, U+30DF, U+30E1, U+30E2, U+30E3, U+30E5, U+30E7, U+30EE, U+30F0..U+30F3, U+30F5, U+30F6, U+31F0, U+31F1, U+31F2, U+31F3, U+31F4, U+31F5, U+31F6, U+31F7, U+31F8, U+31F9, U+31FA, U+31FB, U+31FC, U+31FD, U+31FE, U+31FF, U+AC00..U+D7A3, U+1100..U+1159, U+1161..U+11A2, U+11A8..U+11F9, U+A000..U+A48C, U+A492..U+A4C6

}

그 외에 특별히 손대지 않음

sql_field_string에 ID라고 입력하면, 예약어라서 그런지 오류가 발생함.

sql_query에서 첫번재 컬럼은 반드시 unique한 primary key 여야 한다고 함.


인덱스 생성
indexer --all

데몬실행
searchd

데몬실행시에 인덱스 실행
indexer --all --rotate


sphinxQL 실행
mysql -h0 -P9306
select * from sph_VIDEO where match('2GT96gdhf7g');









[바로가기 링크] : http://coolx.net/cboard/develop/807



Name
Password
Comment
Copyright © 1999-2017, swindler. All rights reserved. 367,611 visitor ( 1999.1.8-2004.5.26 ), 2,405,771 ( -2017.01.31)

  2HLAB   2HLAB_Blog   RedToolBox   Omil   Omil_Blog