Since around versions 5.1.40 and 5.4.3 CMake structure has changed in MySQL and the former instructions on how to build it with SphinxSE (aka Sphinx storage engine) are outdated. Compiling has become easier and requires fewer steps, for which I will provide a tutorial below. Read more »
MySQL does not support HASH index for several storage engines. The common practice is to emulate them by creating an additional row and maintain it by triggers.
For reasons described below I’ve re-implemented FNV1 and FNV1A 64bit for MySQL – as native functions (performance of MySQL UDFs vs. native functions at kazuho’s blog). To round out the mix I’ve added MurmurHash2, 64A and 64B.
Today I’ve launched Visual Studio 9 2008 and compiled Sphinx, the full-text indexer, as storage engine into MySQL. I’ve limited my effords to the latest 64bit Windows version, because compiling under Linux is with GCC rather trivial.
MySQL 5.1 with SphinxSE for 64bit Windows can be downloaded here.
Just replace your original MySQL files by these from the zipfile.
Follow me on Twitter