<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-2">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Sporočilo</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle17
{font-family:Arial;
color:windowtext;}
span.emailstyle19
{font-family:Arial;
color:navy;}
span.emailstyle20
{font-family:Arial;
color:navy;}
span.EmailStyle21
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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
size=2 color=navy face=Wingdings><span style='font-size:10.0pt;font-family:
Wingdings;color:navy'>L</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Scot</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>----</span></font></p>
<div>
<p><font size=1 color=navy face=Arial><span style='font-size:7.5pt;font-family:
Arial;color:navy'>Scott Dexter</span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;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 size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Thursday,
September 11, 2003</span></font><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> </span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>4:09 PM</span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;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:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Scott,</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>which my.cnf are you
using? my-large.cnf is recommended!</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Also, hardware
specifications? RAM, CPU?</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>And like Michael already
responded, mysql 4.x is very highly recommended!</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>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:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>A.</span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=2 face=Tahoma><span lang=SL style='font-size:10.0pt;
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:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>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:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Scott</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div>
<p style='margin-left:.5in'><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>----</span></font></p>
<p style='margin-left:.5in'><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>Scott Dexter</span></font></p>
</div>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;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:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>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:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Michael</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;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 size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;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 size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Scott</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:1.5in'><font size=1 face=Arial><span style='font-size:
7.5pt;font-family:Arial'>----</span></font></p>
<p style='margin-left:1.5in'><font size=1 face=Arial><span style='font-size:
7.5pt;font-family:Arial'>Scott Dexter</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>---<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:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>---<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>
</body>
</html>
<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>