ssjfyg
Last Updated: February 25, 2016
·
167
· fuzzyalej
8e5df0fe19f1779ae90fbf50fe74e8fa

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 :)

Say Thanks
Respond