<div dir="ltr"><div>That's the max_connections limit, which is set to 1000. Note that that's /not/ the per user limit (max_user_connections is set to 0, or infinite). Unless you're using hundreds of connections, it's unlikely you're causing this issue yourself.</div><div><br></div><div>On the other hand, the current connection count is only 31:</div><div><div>MariaDB [(none)]> show status like 'Threads_Con%';</div><div>+-------------------+-------+</div><div>| Variable_name | Value |</div><div>+-------------------+-------+</div><div>| Threads_connected | 31 |</div><div>+-------------------+-------+</div><div>1 row in set (0.00 sec)</div></div><div><br></div><div>so it's odd it peaks to 1000 at some times.</div><div><br></div><div>Merlijn</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 16 February 2015 at 22:46, Nuria Ruiz <span dir="ltr"><<a href="mailto:nuria@wikimedia.org" target="_blank">nuria@wikimedia.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span class=""><div>><span style="font-size:12.8000001907349px">Our recent problems regarding (2006, 'MySQL server has gone away') </span></div><div><span style="font-size:12.8000001907349px">>seem to have started after the Feb12th re-start but it is true that we have not seen them today or yesterday. </span></div><div><span style="font-size:12.8000001907349px"><br></span></div></span><div>Correction: While the error "<span style="font-size:12.8000001907349px">MySQL server has gone away" does not appear as frequently, we see (also from the 12th) </span><br>OperationalError: (OperationalError) (1040, '<b>Too many connections</b>') </div><div><br></div><div>It might very well be that we need to reconfigure our client to a smaller pool size, if so please let us know what is an acceptable number of concurrent connections to 1 host and we will change our config accordingly.</div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 16, 2015 at 9:15 AM, Nuria Ruiz <span dir="ltr"><<a href="mailto:nuria@wikimedia.org" target="_blank">nuria@wikimedia.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span>><span style="font-size:12.8000001907349px">Nuria, the labsdb restarts were on Feb 12th. Russell mentioned connection problems starting Feb 8th -- just to be sure, can you please double-check and specify a date also?</span><div><br></div></span><div>Our recent problems regarding (2006, 'MySQL server has gone away') seem to have started after the Feb12th re-start but it is true that we have not seen them today or yesterday. </div><div><br></div><div>Maybe the problem has subsided? Will keep an eye for it. </div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Sun, Feb 15, 2015 at 9:00 PM, Sean Pringle <span dir="ltr"><<a href="mailto:springle@wikimedia.org" target="_blank">springle@wikimedia.org</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><span>On Mon, Feb 16, 2015 at 2:38 AM, Nuria Ruiz <span dir="ltr"><<a href="mailto:nuria@wikimedia.org" target="_blank">nuria@wikimedia.org</a>></span> wrote:<br></span><div class="gmail_extra"><div class="gmail_quote"><span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span>><span style="font-size:12.8000001907349px">Which recent restart? The GHOST restarts in late January, or the labsdb restarts last week? Something else?</span></span><div style="font-size:12.8000001907349px">The labs restart last week.</div></div></blockquote><div><br></div></span><div>Nuria, the labsdb restarts were on Feb 12th. Russell mentioned connection problems starting Feb 8th -- just to be sure, can you please double-check and specify a date also?<br><br></div><div>Thanks<br></div></div></div></div>
<br></div></div><span>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org" target="_blank">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></span></blockquote></div><br></div>
</blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br></div>