MySQL FULLTEXT searching

RT Users
1

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?

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).

We’re just a Bunch Of Regular Guys, a collective group that’s trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

2

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).

–
We’re just a Bunch Of Regular Guys, a collective group that’s trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

3

Ruslan Zakirov wrote:> On Sat, Nov 1, 2008 at 4:42 AM, Kelly Jones kelly.terry.jones@gmail.com wrote:

Can RT support MySQL fulltext searching?
No. InnoDB has no fulltext indexes.

Try http://www.sphinxsearch.com/ for a possible solution. Some programming will be required to hook it into RT though.

Cheers,

Matthew

Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on servers Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK

signature.asc (258 Bytes)

4

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

5

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