[rt-users] MySQL FULLTEXT searching

Kenneth Marshall ktm at rice.edu
Sat Nov 1 11:00:35 EDT 2008


On Sat, Nov 01, 2008 at 05:13:07AM +0300, Ruslan Zakirov wrote:
> On Sat, Nov 1, 2008 at 4:42 AM, Kelly Jones <kelly.terry.jones at gmail.com> wrote:
> > Can RT support MySQL fulltext searching?
> No. InnoDB has no fulltext indexes.
> 
> >
> > I can easily create a FULLTEXT index on Attachments, but can I add
> > this to the web interface somehow?
> >
> > 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).
> >
As someone posted, MySQL full-text indexing does not work with
InnoDB tables. I would recommend changing your backend to Oracle
and use the existing full-text patch in the wiki or to PostgreSQL
which should work with minimal changes to the patch. We will be
working on the PostgreSQL full-text support soon. Good luck.

Ken



More information about the rt-users mailing list