Re: [rt-users] Full-Text Search: RT-4.2.11 MySQL 5.6.25 vs MariaDB 10.0.19+Sphinx

2015-06-10 Thread Alex Vandiver
On Wed, 10 Jun 2015 19:47:27 + Paul Hirose pthir...@ucdavis.edu wrote: In short, trying to find the best mechanism for FTS, whether I can use MySQL 5.6.25 InnoDB, or MariaDB 10.0.19 + Sphinx on RHEL 7. My answers below assume RT 4.2.11 -- there were some order-of-magnitude speed

[rt-users] Full-Text Search: RT-4.2.11 MySQL 5.6.25 vs MariaDB 10.0.19+Sphinx

2015-06-10 Thread Paul Hirose
In short, trying to find the best mechanism for FTS, whether I can use MySQL 5.6.25 InnoDB, or MariaDB 10.0.19 + Sphinx on RHEL 7. I'd prefer to use MySQL, since that seems to support FTS by itself. Otherwise, I opt for MariaDB, simply because that has the Sphinx engine built-in to the RPM I