Skip to content

# sphinx, sphinx_snippets() & MySQL 5.5

MySQL Development Open Source Sphinx March 21, 2012March 21, 2012

I’ve written a patch which completes Sphinx’s integration with MySQL 5.5.

Up until a couple months ago, Sphinx would not compile with MySQL 5.5 at all. This is, thankfully, resolved as of Sphinx 2.0.3.

However, to my disdain, I’ve found out that it only partially work: the sphinx_snippets() user defined function is not included within the plugin library. After some quick poking I discovered that it was not added to the build, and when added, would not compile.

I rely on sphinx_snippets() quite a lot, and like it. Eventually I wrote the fix to the snippets_udf.cc which allows it to run in a MySQL 5.5 server.

Here are the changes for the 2.0.4 version of Sphinx:

- snippets_udf.cc
- CMakeLists.txt

Replace your 2.0.4 files with these two and get on compiling your MySQL server.

#### Compilation guide

For completeness, here’s how to compile Percona Server 5.5 with Sphinx 2.0.4 including the above patches:

Get Percona Server source code and Sphinx Search source code.

I’ll be using Percona Server 5.5.21-25.0. I use /data/tmp/mysql as compilation path, and install MySQL on /usr/local/mysql55.

>     mkdir -p /data/tmp/mysql
>     cd /data/tmp/mysql
>     tar xzfv Percona-Server-5.5.21-rel25.0.tar.gz
>     tar xzfv sphinx-2.0.4-release.tar.gz
>     cd Percona-Server-5.5.21-rel25.0/
>     cp -R /data/tmp/mysql/sphinx-2.0.4-release/mysqlse storage/sphinx

Overwrite with patched files included in this post:

>     cp /tmp/CMakeLists.txt storage/sphinx/CMakeLists.txt
>     cp /tmp/snippets_udf.cc storage/sphinx/snippets_udf.cc

Build MySQL:

>     sh BUILD/autorun.sh
>     ./configure --with-plugin-sphinx --prefix=/usr/local/mysql55
>     make
>     sudo make install

Install the mysql55 service:

>     cd /usr/local/mysql55
>     sudo cp support-files/mysql.server /etc/init.d/mysql55

In /etc/bash.bashrc, add:

>     export PATH=/usr/local/mysql55/bin:${PATH}

Start MySQL:

>     sudo service mysql55 start

Login to MySQL as an administrato (typically root) and install Sphinx:

>     mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';
>     mysql> CREATE FUNCTION sphinx_snippets RETURNS STRING SONAME 'ha_sphinx.so';

#### Notes

See also http://sphinxsearch.com/bugs/view.php?id=1090 and http://sphinxsearch.com/forum/view.html?id=8982

- Twitter
- LinkedIn
- WhatsApp
- Email
- Facebook
- Print

###
8
Leave a Reply

8 Comment threads
0 Thread replies
0 Followers
Most reacted comment
Hottest comment thread
3 Comment authors
Recent comment authors

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe
Notify of
Thoughts on using MySQL plugins | code.openark.org

[…] sphinx, sphinx_snippets() & MySQL 5.5 […]

Guest
Sorok7

I got it: [root@fedoraconf lib]# service mysql55 start Starting MySQL (Percona Server)….. ERROR! The server quit without updating PID file (/var/lib/mysql/fedoraconf.pid). [root@fedoraconf lib]# /etc/init.d/mysql55 start Starting MySQL (Percona Server)….. ERROR! The server quit without updating PID file (/var/lib/mysql/fedoraconf.pid). [root@fedoraconf lib]#tail -20 /var/log/mysqld.log 120423 3:12:41 InnoDB: The InnoDB memory heap is disabled 120423 3:12:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120423 3:12:41 InnoDB: Compressed tables use zlib 1.2.3 120423 3:12:41 InnoDB: Initializing buffer pool, size = 512.0M 120423 3:12:41 InnoDB: Completed initialization of buffer pool 120423 3:12:41 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past… Read more »

Guest
Sorok7

Fix it with install db.
But got this
mysql> CREATE FUNCTION sphinx_snippets RETURNS STRING SONAME ‘ha_sphinx.so’;
ERROR 1127 (HY000): Can’t find symbol ‘sphinx_snippets’ in library

Author
shlomi

@Sorok7,
As per first comment: you are right: need to install db. The method above works for existing database as well.
May also need upgrade db.

As per second problem, that’s interesting, and indicates you may have failed to follow the guidelines: sphinx_snippets is not in the library, which is exactly what this post solves. Did you override the two files with the files attached in this post?

Author
shlomi

@Sorok7,
Please run:

nm -gC ha_sphinx.so

can you find sphinx_snippets there?

Guest
gao

hi, great job
now sphinx upgrade to 2.0.6 , can you make a 2.0.6 snippet patch ? thx

Author
shlomi

@gao,

As per http://sphinxsearch.com/bugs/print_bug_page.php?bug_id=1090

This is fixed in r3508, which is supposedly 2.0.7 (not sure).

I’m just wondering whether the patch doesn’t work for 2.0.6? I’m unaware of significant changes.

On compiling TokuDB from source | code.openark.org

[…] sphinx, sphinx_snippets() & MySQL 5.5 […]

wpDiscuz
Send to Email Address Your Name Your Email Address Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.