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

Brad Jorsch (Anomie) bjorsch at wikimedia.org
Wed Nov 12 14:59:58 UTC 2014


On Tue, Nov 11, 2014 at 6:12 PM, 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.
>

Has anyone tried again with MariaDB? Maybe they'll be more sensible since
they're not beholden to MySQL's private agreement that was used as
justification when it was filed with MySQL.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20141112/8fda31a6/attachment.html>


More information about the Labs-l mailing list