root@db1176.eqiad.wmnet[mediabackups]> EXPLAIN select count(*) as count, wiki_name, status_name, backup_status_name FROM files JOIN wikis ON files.wiki = wikis.id JOIN file_status ON files.status = file_status.id JOIN backup_status ON backup_status.id = files.backup_status WHERE wiki_name IN ('nlwiki', 'nowiki', 'plwiki', 'ptwiki', 'svwiki', 'thwiki', 'trwiki', 'zhwiki') GROUP BY wiki, status, backup_status;
root@db1176.eqiad.wmnet[mediabackups]> EXPLAIN select count(*) as count, wiki_name, status_name, backup_status_name FROM files FORCE INDEX(wiki_backup_status) JOIN wikis ON files.wiki = wikis.id JOIN file_status ON files.status = file_status.id JOIN backup_status ON backup_status.id = files.backup_status WHERE wiki_name IN ('nlwiki', 'nowiki', 'plwiki', 'ptwiki', 'svwiki', 'thwiki', 'trwiki', 'zhwiki') GROUP BY wiki, status, backup_status;
root@db1176.eqiad.wmnet[mediabackups]> select count(*) as count, wiki_name, status_name, backup_status_name FROM files FORCE INDEX(wiki_backup_status) JOIN wikis ON files.wiki = wikis.id JOIN file_status ON files.status = file_status.id JOIN backup_status ON backup_status.id = files.backup_status WHERE wiki_name IN ('nlwiki', 'nowiki', 'plwiki', 'ptwiki', 'svwiki', 'thwiki', 'trwiki', 'zhwiki') GROUP BY wiki, status, backup_status;