[Labs-l] Queries slow

[Emilio J. Rodríguez-Posada]

It is important to have the map online for Wiki Loves Monuments. Please,
some help?

Here is the code that access the database
https://github.com/emijrp/wlm-maps/blob/master/ajaxmonuments.php

I think that it closes the db conection corretly, but the error.log says
that I have hit some limit.

2015-09-02 16:10:30: (server.c.1444) [note] sockets disabled, connection
limit reached

Later, in error.log:

2015-09-02 18:32:22: (server.c.1444) [note] sockets disabled, connection
limit reached
2015-09-02 19:06:25: (server.c.1398) [note] sockets enabled again

But the map (markers) doesn't work yet:

https://tools.wmflabs.org/wlm-maps/

So. what is happening?

2015-09-02 20:22 GMT+02:00 Emilio J. Rodríguez-Posada <emijrp at gmail.com>:

> My error.log says:
>
> 2015-09-02 16:10:30: (server.c.1444) [note] sockets disabled, connection
> limit reached
>
> What can I do to fix it? Any performance tips?
>
>
> 2015-09-02 19:53 GMT+02:00 Emilio J. Rodríguez-Posada <emijrp at gmail.com>:
>
>> Hello;
>>
>> SQL queries are quite slow for me right now. I'm not sure if it is an
>> issue of my tool (wlm-maps using erfgoed database) or a general thing.
>>
>> https://tools.wmflabs.org/wlm-maps/#6/36.624/-4.460 (markers don't show)
>>
>> Do I have to kill any process or whatever? I had to restart webservice
>> too, because the tool was unresponsive.
>>
>> Thanks
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150902/67af0b19/attachment.html>