As you might have noticed I switched to C/C++ and Boost (and my own preprocessor) for writing high-performance webapplications. In most cases I write them as module to Nginx.
These resources have been very helpful for me in the beginning: Read more »
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 »
Update 2010-05-17: Emerging gentoo-sources has been replaced by fetching them by GIT and merging Marvell’s and my patches into them.
Compiling on the SheevaPlug can take long but is not neccessary if you have already your desktop pc running (which will be referred to as “workstation”). Unfortunately it will most probably not being run by an ARM processor, therefore you have cross-compile for the plug.
In this post I describe how to install a recent GCC version for cross-compiling, how to compile the latest kernel for the plug and how to enable distributed cross-compiling. By the latter you invoke compiling commands on the SheevaPlug and they will be executed by another machine transparently. 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