<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-2">
<TITLE>Sporočilo</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"
}
SPAN.emailstyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
SPAN.emailstyle19 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.emailstyle20 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle21 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=507322806-12092003><FONT face=Arial color=#0000ff
size=2>Scott,</FONT></SPAN></DIV>
<DIV><SPAN class=507322806-12092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=507322806-12092003><FONT face=Arial color=#0000ff size=2>there
are some docs available on mysql's site, the transition from 3.x to 4.x should
be painless, atleast it was in my case and we're running alot of other
applicatons using php & mysql...</FONT></SPAN></DIV>
<DIV><SPAN class=507322806-12092003><FONT face=Arial color=#0000ff
size=2>Perhaps setup a test environment?</FONT></SPAN></DIV>
<DIV><SPAN class=507322806-12092003><FONT face=Arial color=#0000ff
size=2>A.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=sl dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Scott Dexter
[mailto:scott.dexter@mailsrv.prov.ingenta.com] <BR><B>Sent:</B> Friday,
September 12, 2003 3:06 AM<BR><B>To:</B> 'Aleš Sušnik'; 'RT'<BR><B>Cc:</B>
rt-users@lists.fsck.com<BR><B>Subject:</B> RE: [rt-users] RT 3.0.4 very slow
when replying to tickets via web interface<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Not sure if using
MySQL4 will be possible since RT isn’t the only web app using MySQL. I
was watching top while do some entries, looks like apache/perl may be more
likely culprits. </SPAN></FONT><FONT face=Wingdings color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Wingdings">L</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Scot</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">----</SPAN></FONT></P>
<DIV>
<P><FONT face=Arial color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Arial">Scott
Dexter</SPAN></FONT></P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Aleš
Sušnik [mailto:alesh@sportina.si] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> </SPAN></FONT><FONT face=Tahoma
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, September
11, 2003</SPAN></FONT><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> </SPAN></FONT><FONT face=Tahoma
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">4:09
PM</SPAN></FONT><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> 'Scott Dexter'; 'RT'<BR><B><SPAN
style="FONT-WEIGHT: bold">Cc:</SPAN></B> rt-users@lists.fsck.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [rt-users] RT 3.0.4 very
slow when replying to tickets via web interface</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Scott,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">which
my.cnf are you using? my-large.cnf is recommended!</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Also,
hardware specifications? RAM, CPU?</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">And like
Michael already responded, mysql 4.x is very highly
recommended!</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=blue
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Search
back the mailing list, for august 2003, there are some good mails regarding
speed issues!</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">A.</SPAN></FONT></P></DIV>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face=Tahoma size=2><SPAN lang=SL
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
<B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Scott
Dexter<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday,
September 11, 2003 8:46 PM<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> 'RT'<BR><B><SPAN
style="FONT-WEIGHT: bold">Cc:</SPAN></B> rt-users@lists.fsck.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [rt-users] RT 3.0.4 very
slow when replying to tickets via web interface</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I am
running it on a Red Hat 8.0 box with MySQL3 and apache 1.3.27, the DB isn’t
THAT big, not sure what could be causing this. Not see any particular
load on the machine either, which is very perplexing.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Scott</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Arial">----</SPAN></FONT></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Arial">Scott
Dexter</SPAN></FONT></P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> RT
[mailto:RT@InterCept.Net] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, September 11, 2003 2:42
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Scott
Dexter<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
rt-users@lists.fsck.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [rt-users] RT 3.0.4 very
slow when replying to tickets via web interface</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">It’s
been said in here that mysql 4.0 gives better performance... what os are you
running this on? If you have the resources, backup ur rt3 dir and do a
mysqldump of your rt3 db and use that information on a server with apache2
and mysql 4 and maybe a newer distro of your os. </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Michael</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Scott
Dexter [mailto:scott.dexter@mailsrv.prov.ingenta.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Posted At:</SPAN></B> Thursday, September 11, 2003
2:14 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Posted To:</SPAN></B>
RT<BR><B><SPAN style="FONT-WEIGHT: bold">Conversation:</SPAN></B> [rt-users]
RT 3.0.4 very slow when replying to tickets via web interface<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [rt-users] RT 3.0.4 very slow
when replying to tickets via web interface</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We’re using MySQL, and apache
1.3.27 with mod_perl. When you attempt to reply with the web interface, it
spins it’s wheels for a Long time (60 seconds and more) then finally goes
through. Not seeing high loads on the machine and RT only has 5 users
at any given time, the DB has about 1500 tickets in it. Any
thoughts?</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Scott</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 1.5in"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">----</SPAN></FONT></P>
<P style="MARGIN-LEFT: 1.5in"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">Scott Dexter</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">---<BR>Outgoing mail is certified Virus
Free.<BR>Checked by AVG anti-virus system
(http://www.grisoft.com).<BR>Version: 6.0.516 / Virus Database: 313 -
Release Date: 9/1/2003</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">---<BR>Outgoing mail is certified Virus
Free.<BR>Checked by AVG anti-virus system
(http://www.grisoft.com).<BR>Version: 6.0.516 / Virus Database: 313 -
Release Date: 9/1/2003</SPAN></FONT></P></BLOCKQUOTE></DIV><BR>
<P><FONT size=2>---<BR>Outgoing mail is certified Virus Free.<BR>Checked by
AVG anti-virus system (http://www.grisoft.com).<BR>Version: 6.0.516 / Virus
Database: 313 - Release Date: 9/1/2003<BR></FONT></P></BLOCKQUOTE></BODY></HTML>