[Labs-l] Query takes forever on labsdb

Golden Ring goldenring.wp at gmail.com
Mon Aug 31 01:04:57 UTC 2015


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150831/dd1a85aa/attachment.html>


More information about the Labs-l mailing list