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 <[email protected]> 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
