死玻璃卖宝石发达了,要弄网站做强做大,搞了套icms迁移到阿里云
修改了一些小bug外增加了shpinx检索服务,未做分词优化
apt-get install sphinxsearch vi /etc/sphinxsearch/sphinx.conf source iCMS_article { type = mysql sql_host = localhost sql_user = gemknow sql_pass = gemknow sql_db = gemknow sql_port = 3306 # optional, default is 3306 sql_query_pre = SET NAMES utf8mb4 sql_query_pre = REPLACE INTO gn_sph_counter SELECT 1, MAX(id) FROM gn_article sql_query = SELECT a.id, a.cid,a.userid, a.comments, a.pubdate,a.hits_today, a.hits_yday, a.hits_week, a.hits_month,a.hits, a.haspic, a.title, a.keywords, a.tags, a.status FROM gn_article a,gn_category c WHERE a.cid=c.cid AND a.status ='1' AND a.id<=( SELECT max_doc_id FROM gn_sph_counter WHERE counter_id=1 ) sql_attr_uint = cid sql_attr_uint = userid sql_attr_uint = comments sql_attr_uint = hits sql_attr_uint = hits_week sql_attr_uint = hits_month sql_attr_uint = status sql_attr_timestamp = pubdate sql_attr_bool = haspic sql_ranged_throttle = 0 } source iCMS_article_delta : iCMS_article { sql_query_pre = SET NAMES utf8 sql_query = SELECT a.id, a.cid,a.userid, a.comments, a.pubdate,a.hits_today, a.hits_yday, a.hits_week, a.hits_month,a.hits, a.haspic, a.title, a.keywords, a.tags, a.status FROM gn_article a,gn_category c WHERE a.cid=c.cid AND a.status ='1' AND a.id>( SELECT max_doc_id FROM gn_sph_counter WHERE counter_id=1 ) } index iCMS_article { source = iCMS_article path = /var/lib/sphinxsearch/data/iCMS_article docinfo = extern mlock = 0 morphology = none min_word_len = 1 min_prefix_len = 0 html_strip = 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 } index iCMS_article_delta : iCMS_article { source = iCMS_article_delta path = /var/lib/sphinxsearch/data/iCMS_article_delta } indexer { mem_limit = 128M } searchd { listen = 9312 listen = 9306:mysql41 log = /var/log/sphinxsearch/searchd.log query_log = /var/log/sphinxsearch/query.log read_timeout = 5 client_timeout = 300 max_children = 30 persistent_connections_limit = 30 pid_file = /var/run/sphinxsearch/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 } common { } indexer --all #如果没问题加crontab @hourly /usr/bin/indexer --rotate --config /etc/sphinxsearch/sphinx.conf --all