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.