I am building a full-text search engine that returns results for phrases.
(a) I am trying to match phrases only using SPH_MATCH_PHRASE in SPHINX using PHP. The problem is that when I search for, e.g. "This is a phrase", it also produces relevant results for "This is a phrase" and "a phrase" and "This is a" and "This is" and "phrase" etc.
Actually i am trying to start my Kaltura service. The default "sphinx" came along together with Kaltura has crushed and then got uninstalled. Then i installed clean dedicated of "Sphinx" (source version from here) outside of Kaltura. I setup at /opt/sphinx/. Then when after setup ..
I want to install the latest version of Sphinx Search Engine on top of the MySQL tables on MAMP. My whole web application uses MySQL tables that I test locally using MAMP on a MacBook. However, I can't seem to find a good way to install Sphinx on top of the MySQL of MAMP. I would love a detailed explanation of the installation since I followed the steps of installing Sphinx and it kept failing.
I have problem with sphinx indexer and large (over 1gb database). Seems that its running out of space and I am unable to change the /tmp folder it is using. Googling the error gives lot of mysql related errors, but I have changed all paths in /etc/mysql/* files to /var/tmp which has more available space. Current /tmp folder has 1,4 GB of space and that does not seem to be enough.