Install sphinxSE with MySQL

1. Download the corresponding package

(1) MySQL source code package

(2)sphinx-0.9.tar.gz

Procedure (wget)

2. Installation

1 cd/opt/2 tar-zxvf. mysql-5.1.66.tar.gz 3 tar-zxvf. /sphinx-0.9.9.tar.gz 4 mysqladmin-uroot-pPWD version 5 cd/opt/6 ls7 cp-r. /sph0000-0.9.9/mysqlse /. /mysql-5.1.66/storage/sphinx8 cd. /mysql-5.1.669 sh BUILD/autorun. sh 10. /configure 11 make12 cp storage/sphinx /. libs/ha_sphinx. */usr/lib/mysql/plugin13 mysql-uroot-pPWD mysql> show engines; mysql> install plugin sph?soname' ha _ sph=. so ';

If you see this, the operation is successful.

3. Note: (1) the MySQL source code version must be the same as the MySQL version you have installed. Otherwise

(2) Use :. /configure -- prefix =/usr/local/mysql (. /configure) do not use :. /configure -- prefix =/usr/local/mysql -- with-plugins = sphins (do not use -- with-plugins = sphins)

Remember to generate ha_sphinx.so instead of sphx.. so.