Upgrading from 3.0.4 to 3.0.5

RT Users
1

You should manually apply them!

A.-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Stefan Seiz
Sent: Monday, September 15, 2003 3:30 PM
To: ‘RT Users’; rt-devel@fsck.com
Subject: [rt-users] Upgrading from 3.0.4 to 3.0.5

Hi,

am just upgrading from 3.0.4 to 3.0.5. I thought there had been changes to
the DB indexes etc. to speed up lookups and such. However i don’t find any
scripts for 3.0.5 to 3.0.5 upgrades in etc/upgrades.

Where should i look for database update scripts or aren’t there any?

Thanks!

Stefan Seiz http://www.StefanSeiz.com
Spamto: bin@imd.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

2

OK well could someone help me out and either send the collected db
improvements to the list or email them directly to me, as I don’t seem
to be able to find a concise list of them anywhere;)

Cheers

Ross

3

— rt-3-0-4/etc/schema.mysql 2003-07-12 12:24:37.000000000 +0400
+++ rt-3-0-5/etc/schema.mysql 2003-09-08 22:18:38.000000000 +0400
@@ -125,7 +125,7 @@
Field varchar(40) NULL ,
OldValue varchar(255) NULL ,
NewValue varchar(255) NULL ,

  • Data varchar(100) NULL ,

  • Data varchar(255) NULL ,

    Creator integer NOT NULL DEFAULT 0 ,
    Created DATETIME NULL ,

This is all changes in schema.
All additionall perfomance improvements you could look here:
http://rt3.fsck.com//Ticket/Display.html?id=3390 and dependencies…
acount: guest/guest

Ross Williamson wrote:

4

— rt-3-0-4/etc/schema.mysql 2003-07-12 12:24:37.000000000 +0400
+++ rt-3-0-5/etc/schema.mysql 2003-09-08 22:18:38.000000000 +0400
@@ -125,7 +125,7 @@
Field varchar(40) NULL ,
OldValue varchar(255) NULL ,
NewValue varchar(255) NULL ,

  • Data varchar(100) NULL ,

  • Data varchar(255) NULL ,

    Creator integer NOT NULL DEFAULT 0 ,
    Created DATETIME NULL ,

This is all changes in schema.
All additionall perfomance improvements you could look here:
http://rt3.fsck.com//Ticket/Display.html?id=3390 and dependencies…

I followed all this and still my rt-3-0-5 did not spped up. And then I re-run
the make upgrade from the source and it speeded it up. I have been running it
every ~2 days or so when it I see my RT3 is getting slower

acount: guest/guest

Ross Williamson wrote:

OK well could someone help me out and either send the collected db
improvements to the list or email them directly to me, as I don’t seem
to be able to find a concise list of them anywhere;)

Cheers

Ross

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1