[rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?

[Mark Goodge]

On 13/03/2014 14:32, Kevin Falcone wrote:
> On Thu, Mar 13, 2014 at 02:06:40PM +0000, Mark Goodge wrote:
>> On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote:
>>> We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL
>>> 5.5.35. Management is now asking me to enable full text searching on the
>>> sites so we can search inside the body of the tickets. From what I've
>>> read, our current configuration won't support it due to MySQL 5.5.x not
>>> supporting it natively.
>>
>> MySQL has supported fulltext indexes since version 5.0. What makes you
>> think otherwise?
>
> It supported InnoDB Full Text indexing in 5.0?

No; you need to use MyISAM until 5.6.

But that should not be an issue here; I know that RT uses InnoDB by 
default but there should be no reason why the table you want to search 
can't be converted to MyISAM.

Mark
-- 
My blog: http://mark.goodge.co.uk