<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" 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 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:2.0cm 42.5pt 2.0cm 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=RU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Hello, guys!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>First of all, I would like to thank everyone who
developed and contributed to RT.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>This system is really great and the more I dig into
it the more I love its flexibility compared to rivals.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>I have been reading through these lists for quite
some time now, and finally decided to post my question.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>So, this one probably goes to Ruslan Zakirov, the
author of the Shredder.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>To make a long story short: RT 3.6.1, huge
installation, 150000 (one hundred and fifty thousand) tickets, 30% of them
deleted spam, 20 queues, 80 privileged users.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Mysql 5.0.18, Postfix, Apache/2.2.0, 2.6.15-1.2054_FC5.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>I started to use the Shredder to get rid of at least
spam tickets. A single ticket took about 6 minutes to delete. It took most of the
time to wipe out Cached Group Members.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>After we upgraded to new hardware (C2D, 2G RAM) I
went down to 2.5 minutes per ticket. After that (still with me?) I played
around with mysql_slow.log and indices, as it has been suggested on this list
before (if anybody’s interested I’ll post exactly what I’ve
done).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Now, the ticket deletion takes only 10-15 seconds. Great!
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>However, when I launch rtx-shredder script without –force
option from CLI, so I can see the messages and prompts, there is a delay (a
gap) in process after wiping out previous ticket and starting a new one. On
screen consecutive lines look something like this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>[Wed Mar 14 15:47:19 2007] [warning]:
RT::Attachment-158005 wiped out
(/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>[Wed Mar 14 15:47:19 2007] [warning]: RT::Transaction-330341
wiped out (/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>[Wed Mar 14 15:47:19 2007] [warning]:
RT::Transaction-334128 wiped out
(/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=2 face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>[Wed Mar 14
15:47:19 2007] [warning]: RT::Ticket-31041 wiped out
(/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=2 face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>[Wed Mar 14
15:47:43 2007] [warning]: RT::CachedGroupMember-438043 wiped out
(/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></b></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>[Wed Mar 14 15:47:43 2007] [warning]:
RT::Transaction-330378 wiped out
(/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>[Wed Mar 14 15:47:43 2007] [warning]:
RT::Group-167572 wiped out (/work/opt/rt3/local/lib/RTx/Shredder/Record.pm:198)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>So, there is this gap of 20-30 seconds, which ends up
in approx 17 hours to delete 1000 tickets.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>I wonder, what causes this gap? a dump writing time? If
so, can I run the Shredder without creating a dump?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>I’ll appreciate any help.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Thank you very much!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Kostya.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>