[rt-users] MySQL FULLTEXT searching

[Kenneth Marshall]

On Fri, Oct 31, 2008 at 06:42:57PM -0700, Kelly Jones wrote:
> Can RT support MySQL fulltext searching?
> 
> I can easily create a FULLTEXT index on Attachments, but can I add
> this to the web interface somehow?

I think that RT needs/requires InnoDB tables to function properly.
FULLTEXT indexes in MySQL only work with MyISAM tables, per the
documentation. There is a patch in the wiki to add FULLTEXT to
RT with an Oracle backend and a very similar patch would work
with a PostgreSQL backend. We are planning to use PostgreSQL with
FULLTEXT here and will submit an item to the wiki once we have it
working.

Ken

> 
> Searching for "Content matches 'whatever'" is unusuably slow,
> especially when you have tons of large binary attachments (the
> $DontSearchFileAttachments setting doesn't seem to help much).
>