sphinx-searchHow to use the MySQL protocol in SphinxSearch?
SphinxSearch supports the MySQL protocol, which allows you to access the search engine using the same commands as you would use for a MySQL database. To use the MySQL protocol, you need to start the searchd daemon with the --mysql-socket
option.
searchd --mysql-socket /tmp/mysql.sock
Once the daemon is running, you can connect to it using the mysql
command line client.
mysql -S /tmp/mysql.sock
Code explanation
- Start the searchd daemon with the
--mysql-socket
option. - Connect to the daemon using the
mysql
command line client. - Execute SQL queries against the search engine.
Helpful links
More of Sphinx Search
- How to use regexp_filter in SphinxSearch?
- How to delete data from a realtime index in SphinxSearch?
- How to query a specific index in SphinxSearch?
- How to use forward slash in SphinxSearch?
- How to reload the configuration in SphinxSearch?
- How to use sql_attr_timestamp in SphinxSearch?
- How to offset results in SphinxSearch?
- How to use SphinxSearch with PHP?
- How to configure memory usage in SphinxSearch?
- How to delete an index in SphinxSearch?
See more codes...