<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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="FR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">In order to increase performance and mainly workaround 503 timeout errors, I’m looking for some DB optimizations.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I have more and more users (more than 1000) and I would like to disable errata mailer.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Do you think it’s normal that this table is growing up every day ?
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">spaceschema=# select count(*) from rhnerratanotificationqueue;<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">45917<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">spaceschema=# select modified from rhnerratanotificationqueue limit 5;<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">2013-03-29 08:30:09.82804+00<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">2013-03-29 08:30:09.82804+00<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">2013-04-03 14:20:11.65948+00<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">2013-04-03 14:20:11.65948+00<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US">2013-04-26 02:50:19.440463+00<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And do you think that if I purge this table, I can increase some performances (because value seems very old) ? <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">In addition, I already force email_notify in table rhnUserInfo to 0 but when I looking code it seems this option appears late in the batch:
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><a href="https://git.fedorahosted.org/cgit/spacewalk.git/tree/java/code/src/com/redhat/rhn/taskomatic/task/ErrataMailer.java?id=1ad3fcf6bc5c80cdab76c93cc8ee2eae01967898"><span lang="EN-US">https://git.fedorahosted.org/cgit/spacewalk.git/tree/java/code/src/com/redhat/rhn/taskomatic/task/ErrataMailer.java?id=1ad3fcf6bc5c80cdab76c93cc8ee2eae01967898</span></a><span lang="EN-US">
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Do you think it’s possible to add a global option which force results to null in order to bypass this job ?
</span><span lang="EN-US" style="font-family:Wingdings">J</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<b><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">public</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#830000;mso-fareast-language:FR">void</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#010181;mso-fareast-language:FR">execute</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">(JobExecutionContext context,
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#830000;mso-fareast-language:FR">boolean</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR"> testContext)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">
<b>throws</b> JobExecutionException {<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR"> <b>try</b> {<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR"> List results =
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#010181;mso-fareast-language:FR">getErrataToProcess</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">();<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">
<b>if</b> (results == null || results.</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#010181;mso-fareast-language:FR">size</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">()
== </span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#2928FF;mso-fareast-language:FR">0</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">) {<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">
<b>if</b> (logger.</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#010181;mso-fareast-language:FR">isDebugEnabled</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">())
{<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR"> logger.</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#010181;mso-fareast-language:FR">debug</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">(</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:red;mso-fareast-language:FR">"No
errata found...exiting"</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR">);<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR"> }
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:45.8pt;line-height:14.65pt;background:white">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:black;mso-fareast-language:FR"> }<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thank you in advance<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:black;mso-fareast-language:FR"><img border="0" width="150" height="5" id="Image_x0020_1" src="cid:image001.gif@01D003E0.0D9B65F0" alt="WL_Dots_signature"></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:black;mso-fareast-language:FR"><br>
</span><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR">Sébastien NAHELOU<o:p></o:p></span></b></p>
<p class="MsoNormal"><i><span style="color:#1F497D;mso-fareast-language:FR">Ingénieur système mutu</span></i><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:black;mso-fareast-language:FR"><br>
</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;mso-fareast-language:FR">Worldline – Seclin - France<br>
+33(0)3.20.60.97.06</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222;mso-fareast-language:FR"> </span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;mso-fareast-language:FR"><br>
</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR"><a href="http://www.worldline.com/"><span style="color:blue">www.worldline.com</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR"><img border="0" width="150" height="37" id="Image_x0020_2" src="cid:image002.gif@01D003E0.0D9B65F0" alt="WL_Logo_signature"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le
détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus,
l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis.<br>
<br>
This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet,
the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting
from any virus transmitted.<br>
</font>
</body>
</html>