[rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Micah Gersten
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 http://www.onshore.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Jesse Vincent
On Mon, Nov 19, 2007 at 09:43:07AM -0600, Micah Gersten wrote: 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

RE: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Micah Gersten
[mailto:[EMAIL PROTECTED] 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 On Mon, Nov 19, 2007 at 09:43:07AM -0600, Micah Gersten wrote: Has anyone upgraded from MySQL 4.0 to 5 running RT 3.6.0 and seen

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Jesse Vincent
On Mon, Nov 19, 2007 at 09:50:46AM -0600, Micah Gersten wrote: 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

RE: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Micah Gersten
@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.0 and MySQL 5 On Mon, Nov 19, 2007 at 09:50:46AM -0600, Micah Gersten wrote: 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

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Jesse Vincent
On Mon, Nov 19, 2007 at 10:13:20AM -0600, Micah Gersten wrote: Is there a guide for how to tune MySQL for RT? I'd recommend High Performance MySQL by O'Reilly. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF

RE: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread 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

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Brian Kerr
On Nov 19, 2007 10:50 AM, Micah Gersten [EMAIL PROTECTED] wrote: 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

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Jesse Vincent
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

RE: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Micah Gersten
Gersten Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT 3.6.0 and MySQL 5 On Nov 19, 2007 10:50 AM, Micah Gersten [EMAIL PROTECTED] wrote: 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

Re: [rt-users] RT 3.6.0 and MySQL 5

2007-11-19 Thread Emmanuel Lacour
On Mon, Nov 19, 2007 at 10:41:12AM -0600, Micah Gersten wrote: 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