[Labs-l] Query takes forever on labsdb

Mon Aug 31 01:42:41 UTC 2015

Yes, it is because MySQL requires you to have permission to SELECT on the
underlying tables, which are sensitive and can't be exposed to labs.

See https://phabricator.wikimedia.org/T50875

On 31 August 2015 at 02:04, Golden Ring <goldenring.wp at gmail.com> wrote:

> Is the reason that ordinary users can't EXPLAIN most queries in the
> replicas that it requires the SELECT privilege on the underlying tables,
> and this is withheld for privacy reasons (the view NULLs out the password,
> email, options, token etc)?
>
> GoldenRing
>
> On 30 August 2015 at 23:48, Platonides <platonides at gmail.com> wrote:
>
>> On 31/08/15 00:17, Huji Lee wrote:
>>
>>> Oh that is smart!
>>>
>>> By the way, after some exploration I figured out I really don't know how
>>> to connect to a specific labsdb instance. What is the host name I should
>>> be using on command line? fawiki.labsdb001 is not the answer.
>>>
>>
>>
>> mysql -h labsdb1001.eqiad.wmnet  fawiki_p
>>
>>
>>
>> _______________________________________________
>> 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/20150831/29d5d283/attachment-0001.html>