[Labs-l] Tool labs replicas are missing the indexes?

Wed Nov 12 01:43:23 UTC 2014

Back to the missing index issue in regards to revision_userindex, what is the status of that?

Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator

> On Nov 11, 2014, at 18:12, Marc A. Pelletier <marc at uberbox.org> wrote:
> 
> On 11/11/2014 02:49 PM, Giovanni Luca Ciampaglia wrote:
>> It's VERY unfortunate that explain does not work -- how am I supposed to
>> debug my queries then? No explain privilege => more unoptimized queries
>> => more queries will be killed => more users will be unhappy => less
>> people will use the LabsDB. 
> 
> It's not a question of privilege, but a change in Mysql to prevent
> explanation on views you do not have select for on the underlying table.
> That's an upstream misfeature they do not accept as a bug.
> 
> That said, SHOW EXPLAIN does work, for running queries, and IIRC someone
> ever wrote a tool to do it for you although I cannot recall what its
> name is offhand.
> 
> -- Marc
> 
> 
> _______________________________________________
> 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/20141111/29094120/attachment.html>