[rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx?

Alex Vandiver alexmv at bestpractical.com
Thu Mar 13 11:39:36 EDT 2014


On Thu, 2014-03-13 at 14:47 +0000, Mark Goodge wrote:
> I know that RT uses InnoDB by default but there should be no reason why
> the table you want to search can't be converted to MyISAM.

There's a very straightforward reason why RT uses InnoDB: database-level
transactions.  Converting the Attachments table to MyISAM would break a
notable number of internals.
 - Alex




More information about the rt-users mailing list