<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple><!--ppd1000037--><!--ppd1000035-->
<div class=WordSection1>
<p class=MsoNormal><span style='font-family:"Courier New"'>I'm converting a
2.0.15 RT system with mysql to 3.8.8 using Kai's scripts.[1]<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>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<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>Thanks in advance:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Attachments1 ON Attachments (Parent) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Attachments2 ON Attachments (TransactionId) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Attachments3 ON Attachments (Parent, TransactionId) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX Links4
ON Links(Type,LocalBase);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Principals2 ON Principals (ObjectId);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX Groups2
On Groups (lower(Type), lower(Domain), Instance);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Transactions1 ON Transactions (ObjectType, ObjectId);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
ACL1 on ACL(ObjectId, ObjectType);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
ACL2 ON ACL(PrincipalId, PrincipalType);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
ACL3 ON ACL(RightName);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
CachedGroupMembers2 on CachedGroupMembers (MemberId);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
CachedGroupMembers3 on CachedGroupMembers (GroupId);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
DisGrouMem on CachedGroupMembers (GroupId,MemberId,Disabled);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX Users3
ON Users (lower(EmailAddress));<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX Users4
ON Users (EmailAddress);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Tickets1 ON Tickets (Queue, Status) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Tickets2 ON Tickets (Owner) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Tickets3 ON Tickets (EffectiveId) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Tickets4 ON Tickets (id, Status) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Tickets5 ON Tickets (id, EffectiveId) ;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
ObjectCustomFieldValues1 ON ObjectCustomFieldValues
(CustomField,ObjectType,ObjectId,Content);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
ObjectCustomFieldValues2 ON ObjectCustomFieldValues
(CustomField,ObjectType,ObjectId);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX CustomFieldValues1
ON CustomFieldValues (CustomField);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Attributes1 on Attributes(Name);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>CREATE INDEX
Attributes2 on Attributes(ObjectType, ObjectId);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>[1] - http://bonsai.xs4all.nl/cgi-bin/gitweb.cgi?p=rt-migration.git<o:p></o:p></span></p>
</div>
<br /><br /><FONT size=2 face=Verdana><STRONG>Josh Narins</STRONG></FONT><BR><BR><FONT size=1
face=Verdana>Director of Application Development<BR>SeniorBridge<BR>845 Third Ave<br/>
7th Floor<BR>New York, NY 10022 <br/>
Tel: (212) 994-6194 <br/>
Fax: (212) 994-4260 <br/>
Mobile:
(917) 488-6248<BR>jnarins@seniorbridge.com<BR><A
href="http://www.seniorbridge.com/">seniorbridge.com</A></FONT><BR><BR><IMG
border=0 hspace=0 alt=SeniorBridge align=baseline
src="http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif"></FONT><br /><br />
<HR style="HEIGHT: 1px">
<FONT size=1 face=Verdana><STRONG>SeniorBridge Statement of
Confidentiality:</STRONG> 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.</FONT></body>
</html>