RT 3.6.0 and MySQL 5

RT Users
1

Has anyone upgraded from MySQL 4.0 to 5 running RT 3.6.0 and seen any speed
improvements?

Thank you,

Micah Gersten

onShore Networks

2

Has anyone upgraded from MySQL 4.0 to 5 running RT 3.6.0 and seen any speed
improvements?

You’ll get a lot more bang for your buck by upgrading to RT 3.6.5 and/or
tuning mysql. If you’re going to MySQL 5, be sure to go to 5.0.45.
(See posts on rt-devel this weekend for info about the issue mysql fixed
in 5.0.45)

-j

3

So, it would be better if I tune 4 than upgrade to 5? I’m not sure my boss
is ready to upgrade to 3.6.5 yet as it just came out a month ago. How
stable is 3.6.5 compared to 3.6.0?

Thank you,
Micah Gersten
onShore Networks
http://www.onshore.comFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Monday, November 19, 2007 9:49 AM
To: Micah Gersten
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 3.6.0 and MySQL 5

Has anyone upgraded from MySQL 4.0 to 5 running RT 3.6.0 and seen any
speed
improvements?

You’ll get a lot more bang for your buck by upgrading to RT 3.6.5 and/or
tuning mysql. If you’re going to MySQL 5, be sure to go to 5.0.45.
(See posts on rt-devel this weekend for info about the issue mysql fixed
in 5.0.45)

-j

4

So, it would be better if I tune 4 than upgrade to 5?

Generally, I’d recommend tuning what you have, rather than starting over
with another unknown quantity. Make sure you’re current on 4.x and then
make sure you have a configuration that’s using your system respurces
well.

I’m not sure my boss
is ready to upgrade to 3.6.5 yet as it just came out a month ago. How
stable is 3.6.5 compared to 3.6.0?

Well, the 3.6.x series is primarily bugfixes, performance and stability
improvements. So, you’re running code that’s about a year behind on
bugfixes, performance and stability improvements.

5

Is there a guide for how to tune MySQL for RT?

Thank you,
Micah Gersten
onShore Networks
http://www.onshore.comFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Monday, November 19, 2007 10:11 AM
To: Micah Gersten
Cc: ‘Jesse Vincent’; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 3.6.0 and MySQL 5

So, it would be better if I tune 4 than upgrade to 5?

Generally, I’d recommend tuning what you have, rather than starting over
with another unknown quantity. Make sure you’re current on 4.x and then
make sure you have a configuration that’s using your system respurces
well.

I’m not sure my boss
is ready to upgrade to 3.6.5 yet as it just came out a month ago. How
stable is 3.6.5 compared to 3.6.0?

Well, the 3.6.x series is primarily bugfixes, performance and stability
improvements. So, you’re running code that’s about a year behind on
bugfixes, performance and stability improvements.

6

Is there a guide for how to tune MySQL for RT?

I’d recommend “High Performance MySQL” by O’Reilly.

7

Were there any DB changes from 3.6.0 to 3.6.5? Is it easy to revert back if
there are problems?

Thank you,
Micah Gersten
onShore Networks
http://www.onshore.com-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Monday, November 19, 2007 10:11 AM
To: Micah Gersten
Cc: ‘Jesse Vincent’; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 3.6.0 and MySQL 5

I’m not sure my boss
is ready to upgrade to 3.6.5 yet as it just came out a month ago. How
stable is 3.6.5 compared to 3.6.0?

Well, the 3.6.x series is primarily bugfixes, performance and stability
improvements. So, you’re running code that’s about a year behind on
bugfixes, performance and stability improvements.

8

So, it would be better if I tune 4 than upgrade to 5? I’m not sure my boss
is ready to upgrade to 3.6.5 yet as it just came out a month ago. How
stable is 3.6.5 compared to 3.6.0?

If you stick with Mysql4, make sure you use 4.1.18. There are query
optimizer changes in versions above it that negatively affect
performance. There was a thread open regarding this but I think it
died out.

-Brian

9

Micah Gersten wrote:

Were there any DB changes from 3.6.0 to 3.6.5? Is it easy to revert back if
there are problems?

You should have a look at the RT upgrade procedure to check out what
changed, but as a matter of policy we don’t make incompatible database
changes withn a stable release series.

10

Should we upgrade from 4.0.24 to 4.1.11a? We’re running debian and these
are the packages available.

Thank you,
Micah Gersten
onShore Networks
http://www.onshore.comFrom: Brian Kerr [mailto:kerrboy@gmail.com]
Sent: Monday, November 19, 2007 10:27 AM
To: Micah Gersten
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 3.6.0 and MySQL 5

So, it would be better if I tune 4 than upgrade to 5? I’m not sure my
boss
is ready to upgrade to 3.6.5 yet as it just came out a month ago. How
stable is 3.6.5 compared to 3.6.0?

If you stick with Mysql4, make sure you use 4.1.18. There are query
optimizer changes in versions above it that negatively affect
performance. There was a thread open regarding this but I think it
died out.

-Brian

11

Should we upgrade from 4.0.24 to 4.1.11a? We’re running debian and these
are the packages available.

FYI, I’m running also RT on Debian (etch) here with RT 3.6.3 and mysql-server
5.0.32-7etch1.

This server was previously using sarge + mysql 4.1.x, there were not
upgrade problem with MySQL, all is working fine here.