這是sphinx.conf 的內容
source src1
{
type = mysql sql_host = localhost sql_user = root sql_pass = 1goodlusslulU sql_db = fangxinjia_sku sql_port = 3306 # optional, default is 3306 sql_query_pre = SET NAMES utf8 # sql_query_pre = SET SESSION query_cache_type=OFF sql_query = \ SELECT product_attribute_id,product_name \ FROM product_attribute sql_attr_uint = product_attribute_id sql_attr_string = product_name
}
這是我建立索引的命令 /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
執行完 一直是這個結果,
Sphinx 2.2.10-id64-release (2c212e0)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/usr/local/sphinx/etc/sphinx.conf'...
skipping non-plain index 'product_attribute'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
求教有什麼問題,感謝
mysql庫中有檔案,索引執行命運也沒有報錯,但就是沒資料
回複內容:
這是sphinx.conf 的內容
source src1
{
type = mysql sql_host = localhost sql_user = root sql_pass = 1goodlusslulU sql_db = fangxinjia_sku sql_port = 3306 # optional, default is 3306 sql_query_pre = SET NAMES utf8 # sql_query_pre = SET SESSION query_cache_type=OFF sql_query = \ SELECT product_attribute_id,product_name \ FROM product_attribute sql_attr_uint = product_attribute_id sql_attr_string = product_name
}
這是我建立索引的命令 /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
執行完 一直是這個結果,
Sphinx 2.2.10-id64-release (2c212e0)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/usr/local/sphinx/etc/sphinx.conf'...
skipping non-plain index 'product_attribute'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
求教有什麼問題,感謝
mysql庫中有檔案,索引執行命運也沒有報錯,但就是沒資料
沒有配置index
index src1 {
source src1;…
}