RT and mysql 5

Has anyone tried running RT with mysql 5.0.x? We’re currently running
4.0.x, with an upgrade to 4.1.x coming in the near future. I’m a bit
leery of 5.0.x because of the various reports I’ve heard (JOIN syntax
changed, major new version, etc).

Thanks,
Drew
Drew Taylor * Web development & consulting
Email: drew@drewtaylor.com * Site implementation & hosting
Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres

I am in development stage upgrade rt to 3.6.1 using mysql 5.0.24 for the
past few weeks … I had no problems yet … however I have n’t done any
form of stress testing yet
Roy
Drew Taylor wrote:

Has anyone tried running RT with mysql 5.0.x? We’re currently running
4.0.x, with an upgrade to 4.1.x coming in the near future. I’m a bit
leery of 5.0.x because of the various reports I’ve heard (JOIN syntax
changed, major new version, etc).

We’ve seen some really poor choices by mysql’s query optimizer on 5.0,
but it does work.

Jesse

I am running RT 3.6.1 with MySQL 5.0.24 and had no problem so far.
D�rio

Drew Taylor wrote:

I am running RT 3.6.0 with MySQL 5.0.21 and Apache 2.2.2 with no issues
to date.
Jon

Drew Taylor wrote:

Has anyone tried running RT with mysql 5.0.x? We’re currently
running
4.0.x, with an upgrade to 4.1.x coming in the near future. I’m a bit
leery of 5.0.x because of the various reports I’ve heard (JOIN
syntax
changed, major new version, etc).

Thanks,
Drew

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

If you can share, how many tickets are in your database and what
hardware mysql is running on?

Currently we’re ~250k tickets (with lots of large attachments) and 4x
Xeon @3GHz w/ 2GB RAM. The upgrade will add more RAM.

Thanks,
DrewOn 9/11/06, Jon Speck Jr. JSPECK@transunion.com wrote:

I am running RT 3.6.0 with MySQL 5.0.21 and Apache 2.2.2 with no issues
to date.
Jon

Drew Taylor wrote:

Has anyone tried running RT with mysql 5.0.x? We’re currently
running
4.0.x, with an upgrade to 4.1.x coming in the near future. I’m a bit
leery of 5.0.x because of the various reports I’ve heard (JOIN
syntax
changed, major new version, etc).

Drew Taylor * Web development & consulting
Email: drew@drewtaylor.com * Site implementation & hosting
Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres