I’ve installed the sphinx extensions via pecl on ubuntu 8.04 however, after restarting apache, my php program says that SphinxClient hasn’t been found I looked at phpinfo() output and its not there. I’ve looked at where extension_dir is set to and the sphinx.so is there any idea why it won’t load? php version is PHP … Read more
I recently installed sphinx, mysql etc. and everything works fine as well. However, I always get the message: Sphinx cannot be found on your system. You may need to configure the following settings in your config/sphinx.yml file: bin_path searchd_binary_name indexer_binary_name For more information, read the documentation: I configured the bin_path in sphinx.yml to development: bin_path: … Read more
I am trying to install sphinx on my centOS 5.6 x64 if I do yum install sphinx I get only 0.9,9 version, and I’d like to install 2.0.1-beta so I followed the instructions in their documentation and I downloaded source tarball and run ./configure –with-mysql I am getting an error that cannot find mysql include … Read more
Is it possible to add a new resource type to an RHEL or CentOS 6.x cluster, in order to allow Sphinx fulltext search to run alongside MySQL? The clusters are managed using luci/ricci and cman. Answer The trick appears to be to use the “Script” resource type in RHCS / CentOS Cluster, and run Sphinx … Read more
We have heavy load sphinx instance. Index is realtime, but we bulk insert data only once a week or so. It runs on dedicated 12 core / 24 thread server. Server have only sphinx installed. Here is snipped of conf file: index data_all { type = distributed local = data_0 local = data_1 local = … Read more
I’m using Sphinx search engine for my application, and I would like to add ruby code inside the sphinx.conf file to update some values dynamically based on my application server hostname? Is it possible to execute the ruby code inside sphinx.conf? Something like below { type = mysql sql_host = testHost sql_user = test sql_pass … Read more
After upgrade of sphinx from 0.9.8 to 0.9.9 we ran into serious problems with performance. Searchd works on EC2 large instance. Queries started to work much slower and i often could see Z (zombie) searchd processes in top. I expect this may be related to full-scan queries. Did anyone experience anything like this? Answer We … Read more
The boring, necessary details: I’m on Snow Leopard running MySQL locally. I’m trying to install the Sphinx engine for MySQL like so: mysql> install plugin sphinx soname ‘sphinx.so’; ERROR 1127 (HY000): Can’t find symbol ‘_mysql_plugin_interface_version_’ in library I’ve Googled everywhere and can’t seem to find an actual solution to this problem. For example this issue … Read more
I’m running CentOS 5.7 and trying to install Sphinx Search but keep receiving missing dependency errors. $ yum install sphinx … Error: Missing Dependency: libmysqlclient.so.15 is needed by package sphinx-0.9.8.1-3.el5.i386 (epel) Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package sphinx-0.9.8.1-3.el5.i386 (epel) …. I have libmysqlclient.so.16 as part of MySQL / MySQL-devel. My Question: Is there … Read more
I’m trying to install sphinxsearch on a Virtual Private Server that is running Debian GNU/Linux. It seems to depend on upstart-job. Here is the output I get when I try and run the installer. [ps64518]$ sudo dpkg -i sphinxsearch_2.0.4-oneric_amd64.deb Selecting previously deselected package sphinxsearch. (Reading database … 149083 files and directories currently installed.) Unpacking sphinxsearch … Read more
