ssjfyg
Last Updated: February 25, 2016
·
251
· fuzzyalej

Debugging sphinx

If you are a heavy user of thinking sphinx you might have encounter some tricky stuff that could be easily solved if you were able to actually see the indexed data.

Well, you can easily solve that now:
mysql --host 127.0.0.1 --port 9306

With that, you have console access to the index database, that you can query with SphinxQL (http://sphinxsearch.com/docs/current.html#sphinxql-reference)

note: if you are using rails, the ID of the model is not id but sphinx_internal_id :)