Comments on: sphinx, sphinx_snippets() & MySQL 5.5 https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5 Blog by Shlomi Noach Thu, 02 May 2013 05:15:51 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: On compiling TokuDB from source | code.openark.org https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-203905 Thu, 02 May 2013 05:15:51 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-203905 […] sphinx, sphinx_snippets() & MySQL 5.5 […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-169350 Tue, 29 Jan 2013 06:06:42 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-169350 @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.

]]> By: gao https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-169266 Tue, 29 Jan 2013 03:10:49 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-169266 hi, great job
now sphinx upgrade to 2.0.6 , can you make a 2.0.6 snippet patch ? thx

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-86980 Tue, 24 Apr 2012 12:04:30 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-86980 @Sorok7,
Please run:

nm -gC ha_sphinx.so

can you find sphinx_snippets there?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-86979 Tue, 24 Apr 2012 12:03:18 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-86979 @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?

]]> By: Sorok7 https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-86629 Mon, 23 Apr 2012 07:21:12 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-86629 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

]]> By: Sorok7 https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-86626 Mon, 23 Apr 2012 07:14:23 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-86626 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 the checkpoint lsn 50037
120423 3:12:41 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
InnoDB: Doing recovery: scanned up to log sequence number 1597945
120423 3:12:41 InnoDB: Starting an apply batch of log records to the database…
InnoDB: Progress in percents: 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
120423 3:12:42 InnoDB: Waiting for the background threads to start
120423 3:12:43 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1597945
120423 3:12:43 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
120423 03:12:43 mysqld_safe mysqld from pid file /var/lib/mysql/fedoraconf.pid ended

How I can fix it?

]]> By: Thoughts on using MySQL plugins | code.openark.org https://shlomi-noach.github.io/blog/mysql/sphinx-sphinx_snippets-mysql-5-5/comment-page-1#comment-81553 Tue, 03 Apr 2012 11:05:52 +0000 https://shlomi-noach.github.io/blog/?p=4775#comment-81553 […] sphinx, sphinx_snippets() & MySQL 5.5 […]

]]>