Gilles has uploaded a new change for review. https://gerrit.wikimedia.org/r/132943
Change subject: Optimise slow queries ...................................................................... Optimise slow queries Following Sean Pringle's recommendations Change-Id: I430574818d7fe1abb0206d33635840387f547ebe --- M actions/cawiki.sql M actions/commonswiki.sql M actions/czwiki.sql M actions/dewiki.sql M actions/enwiki.sql M actions/enwikivoyage.sql M actions/eswiki.sql M actions/etwiki.sql M actions/fiwiki.sql M actions/frwiki.sql M actions/global.sql M actions/hewiki.sql M actions/huwiki.sql M actions/itwiki.sql M actions/jawiki.sql M actions/kowiki.sql M actions/mediawikiwiki.sql M actions/nlwiki.sql M actions/plwiki.sql M actions/ptwiki.sql M actions/rowiki.sql M actions/ruwiki.sql M actions/skwiki.sql M actions/svwiki.sql M actions/template.sql M actions/tewiki.sql M actions/thwiki.sql M actions/viwiki.sql M generate.php M geoperf/cawiki-api.sql M geoperf/cawiki-image.sql M geoperf/commonswiki-api.sql M geoperf/commonswiki-image.sql M geoperf/czwiki-api.sql M geoperf/czwiki-image.sql M geoperf/dewiki-api.sql M geoperf/dewiki-image.sql M geoperf/enwiki-api.sql M geoperf/enwiki-image.sql M geoperf/enwikivoyage-api.sql M geoperf/enwikivoyage-image.sql M geoperf/eswiki-api.sql M geoperf/eswiki-image.sql M geoperf/etwiki-api.sql M geoperf/etwiki-image.sql M geoperf/fiwiki-api.sql M geoperf/fiwiki-image.sql M geoperf/frwiki-api.sql M geoperf/frwiki-image.sql M geoperf/global-api.sql M geoperf/global-image.sql M geoperf/hewiki-api.sql M geoperf/hewiki-image.sql M geoperf/huwiki-api.sql M geoperf/huwiki-image.sql M geoperf/itwiki-api.sql M geoperf/itwiki-image.sql M geoperf/jawiki-api.sql M geoperf/jawiki-image.sql M geoperf/kowiki-api.sql M geoperf/kowiki-image.sql M geoperf/mediawikiwiki-api.sql M geoperf/mediawikiwiki-image.sql M geoperf/nlwiki-api.sql M geoperf/nlwiki-image.sql M geoperf/plwiki-api.sql M geoperf/plwiki-image.sql M geoperf/ptwiki-api.sql M geoperf/ptwiki-image.sql M geoperf/rowiki-api.sql M geoperf/rowiki-image.sql M geoperf/ruwiki-api.sql M geoperf/ruwiki-image.sql M geoperf/skwiki-api.sql M geoperf/skwiki-image.sql M geoperf/svwiki-api.sql M geoperf/svwiki-image.sql M geoperf/template.sql M geoperf/tewiki-api.sql M geoperf/tewiki-image.sql M geoperf/thwiki-api.sql M geoperf/thwiki-image.sql M geoperf/viwiki-api.sql M geoperf/viwiki-image.sql M perf/cawiki-filerepoinfo.sql M perf/cawiki-globalusage.sql M perf/cawiki-image.sql M perf/cawiki-imagehit.sql M perf/cawiki-imageinfo.sql M perf/cawiki-imagemiss.sql M perf/cawiki-imageusage.sql M perf/cawiki-thumbnailinfo.sql M perf/cawiki-userinfo.sql M perf/commonswiki-filerepoinfo.sql M perf/commonswiki-globalusage.sql M perf/commonswiki-image.sql M perf/commonswiki-imagehit.sql M perf/commonswiki-imageinfo.sql M perf/commonswiki-imagemiss.sql M perf/commonswiki-imageusage.sql M perf/commonswiki-thumbnailinfo.sql M perf/commonswiki-userinfo.sql M perf/czwiki-filerepoinfo.sql M perf/czwiki-globalusage.sql M perf/czwiki-image.sql M perf/czwiki-imagehit.sql M perf/czwiki-imageinfo.sql M perf/czwiki-imagemiss.sql M perf/czwiki-imageusage.sql M perf/czwiki-thumbnailinfo.sql M perf/czwiki-userinfo.sql M perf/dewiki-filerepoinfo.sql M perf/dewiki-globalusage.sql M perf/dewiki-image.sql M perf/dewiki-imagehit.sql M perf/dewiki-imageinfo.sql M perf/dewiki-imagemiss.sql M perf/dewiki-imageusage.sql M perf/dewiki-thumbnailinfo.sql M perf/dewiki-userinfo.sql M perf/enwiki-filerepoinfo.sql M perf/enwiki-globalusage.sql M perf/enwiki-image.sql M perf/enwiki-imagehit.sql M perf/enwiki-imageinfo.sql M perf/enwiki-imagemiss.sql M perf/enwiki-imageusage.sql M perf/enwiki-thumbnailinfo.sql M perf/enwiki-userinfo.sql M perf/enwikivoyage-filerepoinfo.sql M perf/enwikivoyage-globalusage.sql M perf/enwikivoyage-image.sql M perf/enwikivoyage-imagehit.sql M perf/enwikivoyage-imageinfo.sql M perf/enwikivoyage-imagemiss.sql M perf/enwikivoyage-imageusage.sql M perf/enwikivoyage-thumbnailinfo.sql M perf/enwikivoyage-userinfo.sql M perf/eswiki-filerepoinfo.sql M perf/eswiki-globalusage.sql M perf/eswiki-image.sql M perf/eswiki-imagehit.sql M perf/eswiki-imageinfo.sql M perf/eswiki-imagemiss.sql M perf/eswiki-imageusage.sql M perf/eswiki-thumbnailinfo.sql M perf/eswiki-userinfo.sql M perf/etwiki-filerepoinfo.sql M perf/etwiki-globalusage.sql M perf/etwiki-image.sql M perf/etwiki-imagehit.sql M perf/etwiki-imageinfo.sql M perf/etwiki-imagemiss.sql M perf/etwiki-imageusage.sql M perf/etwiki-thumbnailinfo.sql M perf/etwiki-userinfo.sql M perf/fiwiki-filerepoinfo.sql M perf/fiwiki-globalusage.sql M perf/fiwiki-image.sql M perf/fiwiki-imagehit.sql M perf/fiwiki-imageinfo.sql M perf/fiwiki-imagemiss.sql M perf/fiwiki-imageusage.sql M perf/fiwiki-thumbnailinfo.sql M perf/fiwiki-userinfo.sql M perf/frwiki-filerepoinfo.sql M perf/frwiki-globalusage.sql M perf/frwiki-image.sql M perf/frwiki-imagehit.sql M perf/frwiki-imageinfo.sql M perf/frwiki-imagemiss.sql M perf/frwiki-imageusage.sql M perf/frwiki-thumbnailinfo.sql M perf/frwiki-userinfo.sql M perf/global-filerepoinfo.sql M perf/global-globalusage.sql M perf/global-image.sql M perf/global-imagehit.sql M perf/global-imageinfo.sql M perf/global-imagemiss.sql M perf/global-imageusage.sql M perf/global-thumbnailinfo.sql M perf/global-userinfo.sql M perf/hewiki-filerepoinfo.sql M perf/hewiki-globalusage.sql M perf/hewiki-image.sql M perf/hewiki-imagehit.sql M perf/hewiki-imageinfo.sql M perf/hewiki-imagemiss.sql M perf/hewiki-imageusage.sql M perf/hewiki-thumbnailinfo.sql M perf/hewiki-userinfo.sql M perf/huwiki-filerepoinfo.sql M perf/huwiki-globalusage.sql M perf/huwiki-image.sql M perf/huwiki-imagehit.sql M perf/huwiki-imageinfo.sql M perf/huwiki-imagemiss.sql M perf/huwiki-imageusage.sql M perf/huwiki-thumbnailinfo.sql M perf/huwiki-userinfo.sql M perf/itwiki-filerepoinfo.sql M perf/itwiki-globalusage.sql M perf/itwiki-image.sql M perf/itwiki-imagehit.sql M perf/itwiki-imageinfo.sql M perf/itwiki-imagemiss.sql M perf/itwiki-imageusage.sql M perf/itwiki-thumbnailinfo.sql M perf/itwiki-userinfo.sql M perf/jawiki-filerepoinfo.sql M perf/jawiki-globalusage.sql M perf/jawiki-image.sql M perf/jawiki-imagehit.sql M perf/jawiki-imageinfo.sql M perf/jawiki-imagemiss.sql M perf/jawiki-imageusage.sql M perf/jawiki-thumbnailinfo.sql M perf/jawiki-userinfo.sql M perf/kowiki-filerepoinfo.sql M perf/kowiki-globalusage.sql M perf/kowiki-image.sql M perf/kowiki-imagehit.sql M perf/kowiki-imageinfo.sql M perf/kowiki-imagemiss.sql M perf/kowiki-imageusage.sql M perf/kowiki-thumbnailinfo.sql M perf/kowiki-userinfo.sql M perf/mediawikiwiki-filerepoinfo.sql M perf/mediawikiwiki-globalusage.sql M perf/mediawikiwiki-image.sql M perf/mediawikiwiki-imagehit.sql M perf/mediawikiwiki-imageinfo.sql M perf/mediawikiwiki-imagemiss.sql M perf/mediawikiwiki-imageusage.sql M perf/mediawikiwiki-thumbnailinfo.sql M perf/mediawikiwiki-userinfo.sql M perf/nlwiki-filerepoinfo.sql M perf/nlwiki-globalusage.sql M perf/nlwiki-image.sql M perf/nlwiki-imagehit.sql M perf/nlwiki-imageinfo.sql M perf/nlwiki-imagemiss.sql M perf/nlwiki-imageusage.sql M perf/nlwiki-thumbnailinfo.sql M perf/nlwiki-userinfo.sql M perf/plwiki-filerepoinfo.sql M perf/plwiki-globalusage.sql M perf/plwiki-image.sql M perf/plwiki-imagehit.sql M perf/plwiki-imageinfo.sql M perf/plwiki-imagemiss.sql M perf/plwiki-imageusage.sql M perf/plwiki-thumbnailinfo.sql M perf/plwiki-userinfo.sql M perf/ptwiki-filerepoinfo.sql M perf/ptwiki-globalusage.sql M perf/ptwiki-image.sql M perf/ptwiki-imagehit.sql M perf/ptwiki-imageinfo.sql M perf/ptwiki-imagemiss.sql M perf/ptwiki-imageusage.sql M perf/ptwiki-thumbnailinfo.sql M perf/ptwiki-userinfo.sql M perf/rowiki-filerepoinfo.sql M perf/rowiki-globalusage.sql M perf/rowiki-image.sql M perf/rowiki-imagehit.sql M perf/rowiki-imageinfo.sql M perf/rowiki-imagemiss.sql M perf/rowiki-imageusage.sql M perf/rowiki-thumbnailinfo.sql M perf/rowiki-userinfo.sql M perf/ruwiki-filerepoinfo.sql M perf/ruwiki-globalusage.sql M perf/ruwiki-image.sql M perf/ruwiki-imagehit.sql M perf/ruwiki-imageinfo.sql M perf/ruwiki-imagemiss.sql M perf/ruwiki-imageusage.sql M perf/ruwiki-thumbnailinfo.sql M perf/ruwiki-userinfo.sql M perf/skwiki-filerepoinfo.sql M perf/skwiki-globalusage.sql M perf/skwiki-image.sql M perf/skwiki-imagehit.sql M perf/skwiki-imageinfo.sql M perf/skwiki-imagemiss.sql M perf/skwiki-imageusage.sql M perf/skwiki-thumbnailinfo.sql M perf/skwiki-userinfo.sql M perf/svwiki-filerepoinfo.sql M perf/svwiki-globalusage.sql M perf/svwiki-image.sql M perf/svwiki-imagehit.sql M perf/svwiki-imageinfo.sql M perf/svwiki-imagemiss.sql M perf/svwiki-imageusage.sql M perf/svwiki-thumbnailinfo.sql M perf/svwiki-userinfo.sql M perf/template.sql M perf/tewiki-filerepoinfo.sql M perf/tewiki-globalusage.sql M perf/tewiki-image.sql M perf/tewiki-imagehit.sql M perf/tewiki-imageinfo.sql M perf/tewiki-imagemiss.sql M perf/tewiki-imageusage.sql M perf/tewiki-thumbnailinfo.sql M perf/tewiki-userinfo.sql M perf/thwiki-filerepoinfo.sql M perf/thwiki-globalusage.sql M perf/thwiki-image.sql M perf/thwiki-imagehit.sql M perf/thwiki-imageinfo.sql M perf/thwiki-imagemiss.sql M perf/thwiki-imageusage.sql M perf/thwiki-thumbnailinfo.sql M perf/thwiki-userinfo.sql M perf/viwiki-filerepoinfo.sql M perf/viwiki-globalusage.sql M perf/viwiki-image.sql M perf/viwiki-imagehit.sql M perf/viwiki-imageinfo.sql M perf/viwiki-imagemiss.sql M perf/viwiki-imageusage.sql M perf/viwiki-thumbnailinfo.sql M perf/viwiki-userinfo.sql 328 files changed, 2,586 insertions(+), 683 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia refs/changes/43/132943/1 -- To view, visit https://gerrit.wikimedia.org/r/132943 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I430574818d7fe1abb0206d33635840387f547ebe Gerrit-PatchSet: 1 Gerrit-Project: analytics/multimedia Gerrit-Branch: master Gerrit-Owner: Gilles <gdu...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
