<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 5.50.4919.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=625372721-13032003>Sorry for the HTML
mail... it was the easiest way to show the data. We're having similar
performance issues with rt-2-1-88. The following is a process list query
in phpMyAdmin, after I had hit "Create a new ticket in". The create page
only turns up after I kill the mysql process below, or after it runs it's
course. It usually runs for more than 200s. Below that is the
imported info from rt2, into the rt3 database. rt2 is on the same server,
and it's lightening fast compared to rt3. Is there any way to improve the
performance?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=625372721-13032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=625372721-13032003>New install of rt3,
import of dumpfile via the 1.5 version of import script. MySQL 3.23.45,
perl 5.8, all dependencies satisfied.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=625372721-13032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=625372721-13032003>/Mike</SPAN></FONT></DIV>
<DIV><SPAN class=625372721-13032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=625372721-13032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=625372721-13032003>
<TABLE cellPadding=5 border=0>
<TBODY>
<TR
onmousedown="setPointer(this, 10, 'click', '#DDDDDD', '#CCFFCC', '#FFCC99');"
onmouseover="setPointer(this, 10, 'over', '#DDDDDD', '#CCFFCC', '#FFCC99');"
onmouseout="setPointer(this, 10, 'out', '#DDDDDD', '#CCFFCC', '#FFCC99');">
<TD vAlign=top align=right bgColor=#ffcc99>75843</TD>
<TD vAlign=top bgColor=#ffcc99>rt_user</TD>
<TD vAlign=top bgColor=#ffcc99>localhost</TD>
<TD vAlign=top bgColor=#ffcc99>rt3</TD>
<TD vAlign=top bgColor=#ffcc99>Query</TD>
<TD vAlign=top bgColor=#ffcc99>196</TD>
<TD vAlign=top bgColor=#ffcc99>Copying to tmp table</TD>
<TD vAlign=top bgColor=#ffcc99>SELECT DISTINCT main.* FROM Users main,
Principals Principals_1, CachedGroupMembers
CachedGroupMembe</TD></TR></TBODY></TABLE></SPAN></DIV>
<DIV> </DIV>
<DIV>
<H1>Database <I><A class=h1
href="http://labnetmgr1/phpMyAdmin/db_details.php?lang=en-iso-8859-1&convcharset=iso-8859-1&server=2&db=rt3"><FONT
color=#000000>rt3</FONT></A></I> running on <I>labs</I> </H1><!-- The tables list -->
<TABLE border=0>
<TBODY>
<TR>
<TH> Table </TH>
<TH>Records</TH>
<TH>Type</TH>
<TH>Size</TH></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>ACL </B> </TD>
<TD align=right bgColor=#dddddd>64 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 8.9 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>Attachments </B> </TD>
<TD align=right bgColor=#cccccc>2,238 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 3.7 MB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>CachedGroupMembers </B> </TD>
<TD align=right bgColor=#dddddd>8,107 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 748.4 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>CustomFieldValues </B> </TD>
<TD align=right bgColor=#cccccc>325 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 23.2 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>CustomFields </B> </TD>
<TD align=right bgColor=#dddddd>21 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 4.4 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>GroupMembers </B> </TD>
<TD align=right bgColor=#cccccc>2,651 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 93.7 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>Groups </B> </TD>
<TD align=right bgColor=#dddddd>3,129 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 442.8 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>Links </B> </TD>
<TD align=right bgColor=#cccccc>83 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 28.7 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>Principals </B> </TD>
<TD align=right bgColor=#dddddd>3,453 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 130.4 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>Queues </B> </TD>
<TD align=right bgColor=#cccccc>3 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 4.4 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>ScripActions </B> </TD>
<TD align=right bgColor=#dddddd>15 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 3.7 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>ScripConditions </B> </TD>
<TD align=right bgColor=#cccccc>9 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 2.9 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>Scrips </B> </TD>
<TD align=right bgColor=#dddddd>22 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 6.6 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>Templates </B> </TD>
<TD align=right bgColor=#cccccc>9 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 5.0 KB </TD></TR>
<TR>
<TD noWrap
bgColor=#dddddd> <B>TicketCustomFieldValues </B> </TD>
<TD align=right bgColor=#dddddd>2,532 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 146.5 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>Tickets </B> </TD>
<TD align=right bgColor=#cccccc>695 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 149.7 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>Transactions </B> </TD>
<TD align=right bgColor=#dddddd>8,005 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 628.2 KB </TD></TR>
<TR>
<TD noWrap bgColor=#cccccc> <B>Users </B> </TD>
<TD align=right bgColor=#cccccc>323 </TD>
<TD noWrap bgColor=#cccccc> MyISAM </TD>
<TD noWrap align=right bgColor=#cccccc> 97.1 KB </TD></TR>
<TR>
<TD noWrap bgColor=#dddddd> <B>sessions </B> </TD>
<TD align=right bgColor=#dddddd>1 </TD>
<TD noWrap bgColor=#dddddd> MyISAM </TD>
<TD noWrap align=right bgColor=#dddddd> 9.9 KB </TD></TR>
<TR>
<TH align=middle> <B>19 table(s)</B> </TH>
<TH noWrap align=right><B>31,685</B> </TH>
<TH align=middle><B>--</B> </TH>
<TH noWrap align=right><B>6.1 MB</B>
</TH></TR></TBODY></TABLE></DIV></BODY></HTML>