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 < mviswanat...@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 <phoenixoverr...@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@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/labs-l >> >> > > > -- > --Madhu :) > > _______________________________________________ > Labs-l mailing list > Labs-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/labs-l > >
_______________________________________________ Labs-l mailing list Labs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/labs-l
