[rt-users] Searching Ticket Bodies

[Jeff Fearn]

On 01/09/2013 05:08 AM, Tim Gustafson wrote:
>> http://bestpractical.com/rt/docs/latest/RT_Config.html#FullTextSearch
>> http://bestpractical.com/rt/docs/latest/full_text_indexing.html
>>
>> These are also shipped with RT itself as doc in etc/RT_Config.pm and
>> docs/full_text_indexing.pod.
>
> Hrmm, I remember now.  That documentation states:
>
> "MySQL does not support full-text indexing natively."
>
> Which is untrue.  MySQL does indeed have full-text indexing, and the
> most recent version has full-text indexing with InnoDB tables.  Is
> there any hope for taking advantage of the FTS built-in to MySQL?  My
> MySQL server does a *lot* more than just RT, and re-compiling the
> whole thing with an add-on that gets used by exactly one database (out
> of, let's say, 400 databases) seems sub-optimal.
>

MySQL >= 5.1 can use sphinx as a plugin. You might be able to find a pre 
compiled library for your system, otherwise you can compile the plugin 
yourself. See 
:http://www.howtoforge.com/sphinx-as-mysql-storage-engine-sphinxse

Cheers, Jeff.