[Labs-l] long running queries

Sat Sep 23 00:40:52 UTC 2017

The query I am using in this case is

*:select pl_title, count(*) from pagelinks  left join page on pl_title =
page_title  where pl_namespace = 0  and pl_from_namespace  = 0 and page_id
IS NULL  group by pl_title having COUNT(*) > 100 LIMIT 50; *

I am also running this on enwiki where the table is probably the largest. I
am attempting to locate red linked pages via number of incoming links. I
would expect it to take an hour or more to run probably, given the size of
the table. But I am getting the error message in the phab ticket: ERROR
2006 (HY000): MySQL server has gone away

On Fri, Sep 22, 2017 at 7:53 PM, Madhumitha Viswanathan <
mviswanathan at wikimedia.org> wrote:

> Hi John,
>
> Please provide us with a bit more information so we can help - which host
> are you connecting to, what long running queries are you trying to run,
> etc. I believe you may be running into some timeout/mechanisms that we have
> set up to prevent abuse, see - https://phabricator.
> wikimedia.org/T76956#948591.
>
> As always, feel free to reach out to us on #wikimedia-cloud for any
> questions.
>
> Thanks,
>
> On Fri, Sep 22, 2017 at 1:29 PM, John <phoenixoverride at gmail.com> wrote:
>
>> Do we have a way of letting SQL queries run for a day or so? Im using the
>> interactive sql <host> and running them that way but the DB host is going
>> away in the middle of the process.
>>
>> _______________________________________________
>> Labs-l mailing list
>> Labs-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>
>>
>
>
> --
> --Madhu :)
>
> _______________________________________________
> 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/20170922/5b4a1bfe/attachment.html>