Показать/Скрыть
source videos {
    type            = mysql
    sql_host        = localhost
    sql_user        = username
    sql_pass        =
    sql_db        = videos
    sql_port        = 3306
    sql_sock        = /var/run/mysqld/mysqld.sock
    sql_query_pre     = SET NAMES utf8
    sql_ranged_throttle    = 500
}
source sasisa_videos : videos {
    sql_query = SELECT 10000000 + s.id as `fake_id`, s.id, \
            s.title, s.description, s.duration \
        FROM sasisa_videos as s \
        WHERE s.id>=$start AND s.id<=$end

    sql_query_range    = SELECT MIN(s.id),MAX(s.id) FROM sasisa_videos as s
    sql_range_step    = 10000
    sql_attr_uint        = duration
    sql_attr_uint        = id
}

index video_search {
    source     = sasisa_videos
    path        = /home/sphinx/video_search
    docinfo    = extern
    morphology    = stem_en, stem_ru
    html_strip    = 1
    charset_type    = utf-8
    min_word_len    = 2
}

indexer {
    mem_limit    = 256M
}
searchd {
    listen        = 127.0.0.1:9304
    log        = /var/log/sphinx/searchd.log
    query_log    = /var/log/sphinx/query.log
    read_timeout    = 5
    max_children    = 30
    pid_file    = /var/log/sphinx/searchd.pid
    max_matches    = 250
    compat_sphinxql_magics = 0
}

Показать/Скрыть
root@localhost:/tmp# indexer --all --config /etc/sphinxsearch/sphinx.conf
Sphinx 2.1.8-release (rel21-r4675)
Copyright (c) 2001-2014, Andrew Aksyonoff
Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'video_search'...
collected 133867 docs, 11.3 MB
sorted 0.9 Mhits, 100.0% done
total 133867 docs, 11344282 bytes
total 119.256 sec, 95124 bytes/sec, 1122.51 docs/sec
total 3 reads, 0.009 sec, 2631.6 kb/call avg, 3.0 msec/call avg
total 23 writes, 0.011 sec, 649.9 kb/call avg, 0.4 msec/call avg

Показать/Скрыть
# /etc/init.d/sphinxsearch start
Starting sphinxsearch: Sphinx 2.0.4-release (r3135)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
listening on 127.0.0.1:9304
precaching index 'video_search'
WARNING: index 'video_search': preload: /home/sphinx/video_search.sph is v.38, binary is v.26; NOT SERVING
FATAL: no valid indexes to serve