Have their been changes in any Indexes between 3.8.4 and 3.8.8?

RT Users
1

I’m converting a 2.0.15 RT system with mysql to 3.8.8 using Kai’s scripts.[1]

For performance reasons, he drops the indices before the insert, then recreates them after. All perfectly logical, but his scripts were based on 3.8.4

I wanted to make sure that no indices had changed between 3.8.4 and 3.8.8 so that the index recreation works as expected.

Thanks in advance:

CREATE INDEX Attachments1 ON Attachments (Parent) ;
CREATE INDEX Attachments2 ON Attachments (TransactionId) ;
CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ;
CREATE INDEX Links4 ON Links(Type,LocalBase);
CREATE INDEX Principals2 ON Principals (ObjectId);
CREATE INDEX Groups2 On Groups (lower(Type), lower(Domain), Instance);
CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId);
CREATE INDEX ACL1 on ACL(ObjectId, ObjectType);
CREATE INDEX ACL2 ON ACL(PrincipalId, PrincipalType);
CREATE INDEX ACL3 ON ACL(RightName);
CREATE INDEX CachedGroupMembers2 on CachedGroupMembers (MemberId);
CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (GroupId);
CREATE INDEX DisGrouMem on CachedGroupMembers (GroupId,MemberId,Disabled);
CREATE INDEX Users3 ON Users (lower(EmailAddress));
CREATE INDEX Users4 ON Users (EmailAddress);
CREATE INDEX Tickets1 ON Tickets (Queue, Status) ;
CREATE INDEX Tickets2 ON Tickets (Owner) ;
CREATE INDEX Tickets3 ON Tickets (EffectiveId) ;
CREATE INDEX Tickets4 ON Tickets (id, Status) ;
CREATE INDEX Tickets5 ON Tickets (id, EffectiveId) ;
CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId,Content);
CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId);
CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
CREATE INDEX Attributes1 on Attributes(Name);
CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);

[1] - http://bonsai.xs4all.nl/cgi-bin/gitweb.cgi?p=rt-migration.git

Josh Narins

Director of Application Development
SeniorBridge
845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Fax: (212) 994-4260
Mobile: (917) 488-6248
jnarins@seniorbridge.com
seniorbridge.comhttp://www.seniorbridge.com/

[http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif]

SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you.

2

I’m converting a 2.0.15 RT system with mysql to 3.8.8 using Kai’s scripts.[1]

For performance reasons, he drops the indices before the insert, then recreates them after. All perfectly logical, but his scripts were based on 3.8.4

I wanted to make sure that no indices had changed between 3.8.4 and 3.8.8 so that the index recreation works as expected.

No index changes have taken place since 3.8.4.
See etc/upgrade/3.8.* for confirmation.

Cheers,
Dominic.

Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford

signature.asc (189 Bytes)

3

I’m converting a 2.0.15 RT system with mysql to 3.8.8 using Kai’s scripts.[1]

For performance reasons, he drops the indices before the insert, then recreates them after. All perfectly logical, but his scripts were based on 3.8.4

I wanted to make sure that no indices had changed between 3.8.4 and 3.8.8 so that the index recreation works as expected.

No index changes have taken place since 3.8.4.
See etc/upgrade/3.8.* for confirmation.

Actually, UPGRADING has something to say about index upgrades on
MySQL and Oracle, you might like to check that out.

Dominic.

Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford

signature.asc (189 Bytes)

4

From: Dominic Hargreaves [mailto:dominic.hargreaves@oucs.ox.ac.uk]
Sent: Sunday, October 03, 2010 7:34 AM
To: Josh Narins
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Have their been changes in any Indexes between
3.8.4 and 3.8.8?

I’m converting a 2.0.15 RT system with mysql to 3.8.8 using Kai’s
scripts.[1]

For performance reasons, he drops the indices before the insert,
then recreates them after. All perfectly logical, but his scripts
were based on 3.8.4

I wanted to make sure that no indices had changed between 3.8.4 and
3.8.8 so that the index recreation works as expected.

No index changes have taken place since 3.8.4.
See etc/upgrade/3.8.* for confirmation.

Actually, UPGRADING has something to say about index upgrades on MySQL
and Oracle, you might like to check that out.

Thank you very much.

Josh Narins
Director of Application Development
SeniorBridge
845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Mobile: (917) 488-6248
Fax: (212) 994-4260
jnarins@seniorbridge.com

SeniorBridge
Managing Complex Chronic Care
http://www.seniorbridge.com

SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you.