These are the steps necessary to compile the SphinxSE plugin for mySQL 5.5. This varies slightly from the 5.1 method because you don't use the ./configure command.

Before you had to run mysqlbug to get the complete ./configure command in order to match SphinxSE to your installed mySQL package. Now you can use cmake instead.

First decompress both mySQL and Sphinx into separate directories then cd into your mySQL source directory. From there copy the SphinxSE source:

cp -R ../sphinx-x.x.x/mysqlse storage/sphinx

Still in the mySQL source directory run this command:

sh BUILD/autorun.sh

Now instead of running ./configure you can run this:

cmake . -DBUILD_CONFIG=mysql_release -DIGNORE_AIO_CHECK=true -DWITH_SPHINX_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/var/lib/mysql -DCMAKE_INSTALL_PREFIX=/usr -DINSTALL_LAYOUT=STANDALONE -DENABLED_PROFILING=ON -DMYSQL_MAINTAINER_MODE=OFF -DWITH_DEBUG=OFF

• You may need to change the DATADIR and INSTALL_PREFIX, but these are for a default RPM installation.

From there you can go ahead and do your make

make

Now if everything compiled correctly you can copy the ha_sphinx.so to your plugin directory. If you don't know where your mySQL plugin directory is you can connect to mySQL and issue this query:

show variables where Variable_name like "%plugin%";