Sphinx search query log analyzer

I found a nice little piece of software again today while cleaning up my development stuff…

Sphinx is an open source full text search server, designed from the ground up with performance, relevance (aka search quality), and integration simplicity in mind. It’s written in C++ and works on Linux (RedHat, Ubuntu, etc), Windows, MacOS, Solaris, FreeBSD, and a few other systems.

Working with sphinx is pretty easy but it’s query log is – like any other access log – not meant to be read or analyzed by humans.¬†Some time ago I wrote a little tool to analyze these log files and extract information about slow queries – the bad ones making your users sad.
Because sphinx itself is open source and free to use, I decided today that I will also share the tool with anyone out there. Have a look at GitHub and try it out.

Get it here: Sphinx query log analyzer

Analyzer screenshot

2 thoughts on “Sphinx search query log analyzer”

  1. Jens, do you have a readme or instructions? I can’t get this to work. The script is generating a file w/in the logs dir but there’s no output to the screen and the generated file has very little information in it.


    1. Hey Charlie,
      once the log file has been analyzed it should be listed by it’s label under “Analyzed logs”. Just click on it and the result will be shown.
      Please add an issue report to github (with the log file attached) if it still doesn’t work.

Leave a Reply

Your email address will not be published. Required fields are marked *