On Nov 27, 2014, at 6:55 AM, Alex Vandiver <ale...@bestpractical.com> wrote: > On 11/26/2014 06:35 PM, Jo Rhett wrote: >> However [doc/full_text_indexing] contains only information on how to >> enable full text indexing, and no information on how to enable it >> without the indexing. > > Mostly because we're afraid of users shooting themselves in the foot. > Regardless, I've committed 2551dca5 which details how to do so. > - Alex
Understood. Just a clarity nitpick :) Although I am confused by your statements that full text indexing isn’t available in MySQL. I’ve used this quite successfully in the past http://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html Likewise, MariaDB has Sphinx support compiled in and available in their packages, which made this process almost trivial to enable. https://mariadb.com/kb/en/mariadb/documentation/storage-engines/sphinx-storage-engine/about-sphinxse/ I found three problems in the config pushed out by the sbin/rt-setup-fulltext-index command: 1. You need to create and chown the var/sphinx directory it references mkdir /opt/rt4/var/sphinx chown -R sphinx:sphinx /opt/rt4/var/sphinx 2. You need to add this binlog path line binlog_path = /opt/rt4/var/sphinx 3. You need to add this compat line or searchd won’t start compat_sphinxql_magics = 0 Easy fixes… -- Jo Rhett +1 (415) 999-1798 Skype: jorhett Net Consonance : net philanthropy to improve open source and internet projects.
