Setting as NDA only because while it is active, it could be used for DOS.
Unauthenticated users can ask for 1-hour long queries, efectively denying the service of a database server by just hitting fast enough.
Hits Tmax Tavg Tsum Hosts Users Schemas 18 1,945 1,332 23,984 db1083 wikiuser enwiki SELECT /* SpecialWhatLinksHere::showIndirectLinks <ip> */ page_id, page_namespace, page_title, rd_from, page_is_redirect FROM (SELECT /*! STRAIGHT_JOIN */ pl_from, rd_from FROM `pagelinks` LEFT JOIN `redirect` ON ((rd_from = pl_from) AND rd_title = 'Contents' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = '12') INNER JOIN `page` ON ((pl_from = page_id)) WHERE pl_namespace = '12' AND pl_title = 'Contents' AND (rd_from is NOT NULL) ORDER BY pl_from LIMIT 102 ) `temp_backlink_range` INNER JOIN `page` ON ((pl_from = page_id)) ORDER BY page_id LIMIT 51 /* c6af36508337896c95736155b3658e6c db1083 enwiki 1945s */ 6 53 15 91 db1083 wikiuser enwiki SELECT /* SpecialWhatLinksHere::showIndirectLinks <ip> */ page_id, page_namespace, page_title, rd_from, page_is_redirect FROM (SELECT /*! STRAIGHT_JOIN */ pl_from, rd_from FROM `pagelinks` LEFT JOIN `redirect` ON ((rd_from = pl_from) AND rd_title = 'Contents' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = '12') INNER JOIN `page` ON ((pl_from = page_id)) WHERE pl_namespace = '12' AND pl_title = 'Contents' ORDER BY pl_from LIMIT 102 ) `temp_backlink_range` INNER JOIN `page` ON ((pl_from = page_id)) ORDER BY page_id LIMIT 51 /* 413819f8da117fd955cc1a72fece6ccf db1083 enwiki 4s */
Those queries look terrible, BTW.