[Labs-l] Labs restart & mysql connections dropping?

Mon Feb 16 22:06:20 UTC 2015

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.

On the other hand, the current connection count is only 31:
MariaDB [(none)]> show status like 'Threads_Con%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| Threads_connected | 31    |
+-------------------+-------+
1 row in set (0.00 sec)

so it's odd it peaks to 1000 at some times.

Merlijn

On 16 February 2015 at 22:46, Nuria Ruiz <nuria at wikimedia.org> wrote:

> >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.
>
> Correction: While the error "MySQL server has gone away" does not appear
> as frequently, we see (also from the 12th)
> OperationalError: (OperationalError) (1040, '*Too many connections*')
>
> 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.
>
>
> On Mon, Feb 16, 2015 at 9:15 AM, Nuria Ruiz <nuria at wikimedia.org> wrote:
>
>> >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?
>>
>> 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.
>>
>> Maybe the problem has subsided? Will keep an eye for it.
>>
>>
>>
>>
>>
>> On Sun, Feb 15, 2015 at 9:00 PM, Sean Pringle <springle at wikimedia.org>
>> wrote:
>>
>>> On Mon, Feb 16, 2015 at 2:38 AM, Nuria Ruiz <nuria at wikimedia.org> wrote:
>>>
>>>> >Which recent restart?  The GHOST restarts in late January, or the
>>>> labsdb restarts last week? Something else?
>>>> The labs restart last week.
>>>>
>>>
>>> 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?
>>>
>>> Thanks
>>>
>>> _______________________________________________
>>> Labs-l mailing list
>>> Labs-l at lists.wikimedia.org
>>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>>
>>>
>>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150216/93a38714/attachment-0001.html>