<div dir="ltr">I haven't had time lately and I couldn't check the files. It would be great the next time to left some copy in case someone else want to look for it.<div><div><br></div><div>Certainly we can and we should improve the way we manage runjobs but I don't think this can be the root cause of our problem.</div></div><div><br></div><div>I have been reading about runjobs and checked our default values (includes/DefaultSetting.php).</div><div><br></div><div>$wgJobRunRate = 1 => means that it will run a job in each page request from the job queue.</div><div>$wgRunJobsAsync = true; => an internal HTTP connection for handling the execution of jobs will be opened, and MediaWiki will return the contents of the page immediately to the client without waiting for the job to complete. </div><div>....</div><div><br></div><div>According to [1], we can improve the performance by processing the job queue periodically in the background using cron (maybe every 30 minutes?) and setting $wgJobRunRate to 0 or we can reduce the calls to RunJobs.php by lowering $wgJobRunRate to a value between 0 and 1. For ex: 0.01 will cause one item in the job queue to run on average every 100 page views (it is just a probability, it is not fixed).</div><div><br></div><div>I understand that we want to lower the calls because every call to a job may take over a second and the user will feel the page loading somewhat sluggish. In this would be worst in our case considering our slow access to disks.</div><div><br></div><div>We can check our current job queue in the following URL: <a href="http://wiki.sugarlabs.org/api.php?action=query&meta=siteinfo&siprop=statistics&format=jsonfm">http://wiki.sugarlabs.org/api.php?action=query&meta=siteinfo&siprop=statistics&format=jsonfm</a>.<br></div><div><br></div><div>I also understand here that in every page request (or page view) mediawiki (PHP) will open a socket to make an internal HTTP request in order to execute RunJobs.php. We can check this in the apache-status file. We can also read in [1]: ".. it (calling runjobs) requires loading a lot of PHP classes in memory on a new process to execute a job, and also makes a new HTTP request that the server must handle". </div><div><br></div><div>So, can we expect one apache process for every call to RunJobs.php? What would happen with many request to wiki.slo?</div><div><br></div><div>In the last event, were all the apache processes (150) executing the runjobs maintenance script at the same time? Are we certainly pointing at runjobs as the main guilty for the apache crashes? </div><div><br></div><div>This last information could help us to improve the performance in our wiki but I don't know how to relate with our main problem.</div><div><br></div><div>[1] <a href="https://www.mediawiki.org/wiki/Manual:Job_queue">https://www.mediawiki.org/wiki/Manual:Job_queue</a></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Feb 25, 2016 at 9:37 AM, Sebastian Silva <span dir="ltr"><<a href="mailto:sebastian@fuentelibre.org" target="_blank">sebastian@fuentelibre.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
lol<br>
<br>
That expIains why it traced back to Boston...<br>
<br>
Hanlon's Razor--"Never attribute to malice that which is adequately
explained by stupidity."<br>
<br>
Regards,<br>
Sebastian<span class=""><br>
<br>
<br>
<br>
<div>On 25/02/16 04:17, Bernie Innocenti
wrote:<br>
</div>
<blockquote type="cite">
<pre>lol, 2001:4830:134:7::11 is sunjammer's ipv6 address... better not plonk
it with iptables even if it sends nasty queries <span title=":-)"><span>:-)</span></span>
So, what's calling RunJobs at high rate???
</pre>
</blockquote>
<br>
</span><span class=""><pre cols="72">--
I+D SomosAzucar.Org
"icarito" #somosazucar en Freenode IRC
"Nadie libera a nadie, nadie se libera solo. Los seres humanos se liberan en comunión" - P. Freire</pre>
</span></div>
<br>_______________________________________________<br>
Systems mailing list<br>
<a href="mailto:Systems@lists.sugarlabs.org">Systems@lists.sugarlabs.org</a><br>
<a href="http://lists.sugarlabs.org/listinfo/systems" rel="noreferrer" target="_blank">http://lists.sugarlabs.org/listinfo/systems</a><br>
<br></blockquote></div><br></div>