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 »
Last Thursday we’ve had a conference about innovativations in IT and systems design here in Hannover. And as its main organizer I held a rather long workshop and speech of about three hours about database (mis)use and which and for what purpose a certain DBMS or storage would fit. In case you missed it, here are the slides (in German). It is about: Read more »
To admit it, I was inclined to title this post “from Europe/Russia with love”, but technology should not be seen national and nginx, Varnish and MonetDB are few of many products I am going to mention.
Here’s “nginx” pronounced like you would say “Jeanny”: “Jeannix”.
Let me turn tendencies into trends and provide me you with what I call the weather forecast of technology: 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.
Follow me on Twitter