User:Mattsmith321/SphinxQL

SphinxQL
The Sphinx search engine has two main interfaces: the API and SphinxQL. The SphinxSearch extension is built on the Sphinx API. SphinxQL is useful for running queries from the command-line to see raw results and data. SphinxQL is another way of querying Sphinx. It uses the MySQL 4.1 transport protocol and for this reason no API is required, any MySQL client can be used instead. SphinxQL is an SQL subset, similar to MySQL. See From API to SphinxQL and Back Again additional information.

NOTE: These instructions are specific to a Windows installation. /* Sun Sep 22 10:08:42.274 2013 conn 1 wall 0.001 found 2884 */ SELECT * FROM wiki_main,wiki_incremental WHERE MATCH('msis') AND page_namespace=0 AND page_is_redirect=0;
 * Set up SphinxQL by making the following changes to the sphinx.conf file in the # searchd settings:
 * Restart the MySQL and Sphinx services to pick up the changes.
 * Perform a search in the wiki application and verify that the SphinxQL output was logged in the query_log file specified:
 * Connect to MySQL via the MySQLSphinxQL port:


 * Run the SphinxQL from the query_log output file: