MySQL Naitive Full-Text Indexing

RT Users
1

Hi,

According to the RT 4.2 docs, MySQL does not support native full-text indexing:

http://www.bestpractical.com/docs/rt/4.2/full_text_indexing.html#MYSQL

According to the MySQL docs, there is support for full-text indexing
for both MYISAM and InnoDB tables as of MySQL 5.6:

http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html

MySQL 5.6 was released initially in 2011, and fully in February of
2013, just over a year ago. I think it’s safe to say that it’s stable
at this point.

Has there been any development towards using the build-in MySQL
full-text indexing for RT?

Tim Gustafson
tjg@ucsc.edu
831-459-5354
Baskin Engineering, Room 313A

2

Hi,

According to the RT 4.2 docs, MySQL does not support native full-text indexing:

Full text indexing - RT 4.2.17 Documentation - Best Practical

According to the MySQL docs, there is support for full-text indexing
for both MYISAM and InnoDB tables as of MySQL 5.6:

http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html

MySQL 5.6 was released initially in 2011, and fully in February of
2013, just over a year ago. I think it’s safe to say that it’s stable
at this point.

Has there been any development towards using the build-in MySQL
full-text indexing for RT?

From what I can see there, the native full-text indexing still doesn’t
support BLOBs, which is a key blocker as Tom has mentioned:

3

From what I can see there, the native full-text indexing still doesn’t
support BLOBs, which is a key blocker as Tom has mentioned:

Bummer; I forgot that the Attachments table used BLOB columns. :
Thanks for reminding me though! :slight_smile:

Tim Gustafson
tjg@ucsc.edu
831-459-5354
Baskin Engineering, Room 313A