MySQL FULLTEXT searching

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.

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.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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.

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)

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

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