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