windows installation Sphinx 3.0.1 (Chinese search)

The introduction of sphinx is not much, please check the document directly

1. Download the latest version of sphinx from the spinx official website.


2. Create a new data and log directory

3. Create a new sphinx.conf configuration file and put it in bin directory

For information about configuration items, please refer to etc/sphinx.conf.dist.
source doc
    type            = mysql
    sql_host        = localhost
    sql_user        = root
    sql_pass        = 123
    sql_db          = test
    sql_port        = 3306
    sql_query_pre   = SET NAMES utf8 
    sql_query       = SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content FROM documents 
    sql_attr_uint       = group_id
    sql_attr_timestamp  = date_added

index testindex
    source          = doc
    path            = E:/wamp64/www/sphinx/data/testindex 
    mlock         = 0 
    min_word_len  = 2 
    min_prefix_len = 0
    min_infix_len = 1
    ngram_len     = 1
    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  

    mem_limit       = 128M

    listen          = 9312
    listen          = 9306:mysql41
    log         = E:/wamp64/www/sphinx/log/searchd.log
    query_log       = E:/wamp64/www/sphinx/log/query.log
    read_timeout        = 5
    max_children        = 30
    pid_file        = E:/wamp64/www/sphinx/log/
    seamless_rotate     = 1
    preopen_indexes     = 1
    unlink_old      = 1
    workers         = threads # for RT to work
    binlog_path     = E:/wamp64/www/sphinx/data

4. Generate index file

The file will be generated in the data directory after success

5. start the searchd service.

(forgot to fill in this step here)
Modify the sql content given on the official website and add Chinese

Update index file

6. Full text search with api

require ( "sphinxapi.php" );
$cl = new SphinxClient ();
$q = "I want to study hard"; //Simulation key
$sql = "";
$mode = SPH_MATCH_ALL;
$host = "";
$port = 9312;
$index = "*";
$cl->SetServer ( $host, $port );
$res = $cl->Query ( $q, $index );

sphinx search only queries sphinx index, not mysql. The id queried from sphinx service is the primary key in MySQL database. Query MySQL according to the primary key. When the content in the database changes, the index should be rebuilt, or a field should be added to the data table to mark whether the data is indexed. When the index is rebuilt, only the records without index are generated, and then they are merged into the index

Tags: MySQL SQL PHP Database

Posted on Fri, 03 Apr 2020 07:02:08 -0700 by tonymontana