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

2014-03-13 Thread Cena, Stephen (ext. 300)
We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35. Management is now asking me to enable full text searching on the sites so we can search inside the body of the tickets. From what I've read, our current configuration won't support it due to MySQL 5.5.x not supporting

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

2014-03-13 Thread Mark Goodge
On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote: We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35. Management is now asking me to enable full text searching on the sites so we can search inside the body of the tickets. From what I've read, our current configuration

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

2014-03-13 Thread Kevin Falcone
On Thu, Mar 13, 2014 at 02:06:40PM +, Mark Goodge wrote: On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote: We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35. Management is now asking me to enable full text searching on the sites so we can search inside the

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

2014-03-13 Thread Parish, Brent
...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Mark Goodge Sent: Thursday, March 13, 2014 10:07 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Full text search/index - Migrate to Postgres or MySQL + Sphinx? On 13/03/2014 14:00, Cena, Stephen

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

2014-03-13 Thread Mark Goodge
On 13/03/2014 14:32, Kevin Falcone wrote: On Thu, Mar 13, 2014 at 02:06:40PM +, Mark Goodge wrote: On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote: We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35. Management is now asking me to enable full text searching on

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

2014-03-13 Thread k...@rice.edu
On Thu, Mar 13, 2014 at 02:47:10PM +, Mark Goodge wrote: On 13/03/2014 14:32, Kevin Falcone wrote: On Thu, Mar 13, 2014 at 02:06:40PM +, Mark Goodge wrote: On 13/03/2014 14:00, Cena, Stephen (ext. 300) wrote: We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35.

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

2014-03-13 Thread Alex Vandiver
On Thu, 2014-03-13 at 14:47 +, 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

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

2014-03-13 Thread Guadagnino Cristiano
Cena, Stephen (ext. 300) ha scritto: We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35. Management is now asking me to enable full text searching on the sites so we can search inside the body of the tickets. From what I've read, our current configuration won't support

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

2014-03-13 Thread Cena, Stephen (ext. 300)
Referring to: rt-users Digest, Vol 120, Issue 13, articles 8,9,10,11,13,14,15: Thanks to those who responded. First, no; I did not know that full text indexing was supported after 5.0. I thought that was a 5.6 up coming feature. I must not have a full grasp of how it works, because if MySQL