Skip to content

Instantly share code, notes, and snippets.

@fuzzyalej

fuzzyalej/gist:604f731533c7d3fcd077

Last active August 29, 2015 14:16
Show Gist options
  • Save fuzzyalej/604f731533c7d3fcd077 to your computer and use it in GitHub Desktop.
Save fuzzyalej/604f731533c7d3fcd077 to your computer and use it in GitHub Desktop.
Download ZIP
Debugging Sphinx
Raw
gistfile1.md

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment