source items
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = sphinx_conf
sql_query = SELECT id, title, content, \
UNIX_TIMESTAMP(created) AS created FROM items
sql_attr_timestamp = created
}
index items
{
source = items
path = /usr/local/sphinx/var/data/items-ql
charset_type = utf-8
}
searchd
{
listen = localhost:9306:mysql41
log = /usr/local/sphinx/var/log/ql-searchd.log
query_log = /usr/local/sphinx/var/log/ql-query.log
pid_file = /usr/local/sphinx/var/log/ql-searchd.pid
}

$/usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/sphinx-ql.conf --all

$/usr/local/sphinx/bin/searchd -c /usr/local/sphinx/etc/sphinx-ql.conf

$mysql -u dbuser pdbpass -h localhost -P 9306