Summary
The DiscussionTools tables are not needed on some closed wikis, because the extension is disabled on those wikis
Technical details
- The following closed wikis have DiscussionTools disabled and so do not need the database tables on those wikis:
Wikis without DiscussionTools
aawiki aawikibooks aawiktionary abwiktionary advisorywiki akwiki akwikibooks akwiktionary amwikiquote angwikibooks angwikiquote angwikisource astwikibooks astwikiquote aswikibooks aswiktionary avwiktionary aywikibooks bgwikinews bhwiktionary biwikibooks biwiktionary bmwikibooks bmwikiquote bmwiktionary bowikibooks bowiktionary chowiki chwikibooks chwiktionary cnwikimedia cowikibooks cowikiquote crwikiquote crwiktionary dzwiktionary gawikibooks gawikiquote gnwikibooks gotwikibooks guwikibooks howiki htwikisource huwikinews hzwiki iewikibooks iiwiki ikwiktionary internalwiki kjwiki kkwikiquote knwikibooks krwiki krwikiquote kswikibooks kswikiquote kwwikiquote lbwikibooks lbwikiquote lnwikibooks lrcwiki lvwikibooks mhwiki mhwiktionary miwikibooks mnwikibooks muswiki mywikibooks nahwikibooks nawiki nawikibooks nawikiquote ndswikibooks ndswikiquote ngwiki nzwikimedia pa_uswikimedia piwiktionary pswikibooks qualitywiki quwikibooks quwikiquote rmwikibooks rmwiktionary rnwiktionary scwiktionary sdwikinews searchcomwiki sewikibooks simplewikibooks simplewikiquote snwiktionary spcomwiki strategywiki suwikibooks swwikibooks tenwiki thwikinews tkwikibooks tkwikiquote towiktionary transitionteamwiki trwikinews ttwikiquote twwiktionary ugwikibooks ugwikiquote usabilitywiki uzwikibooks vowikibooks vowikiquote wawikibooks wikimania2005wiki wikimania2006wiki wikimania2007wiki wikimania2008wiki wikimania2009wiki wikimania2010wiki wikimania2011wiki wikimania2012wiki wikimania2013wiki wikimania2014wiki wikimania2015wiki wikimania2016wiki wikimania2017wiki wikimania2018wiki wowikiquote xhwikibooks xhwiktionary yowikibooks yowiktionary zawikibooks zawikiquote zawiktionary zh_min_nanwikibooks zh_min_nanwikiquote zuwikibooks
- Dropping the tables on these wikis should help reduce the number of database tables on s3 and so help with the performance of that cluster
- The following databases are in s5:
mhwiktionary muswiki
Schema change template
- ALTERs to run:
- RENAME TABLE discussiontools_items TO discussiontools_items_temp; RENAME TABLE discussiontools_item_ids TO discussiontools_item_ids_temp; RENAME TABLE discussiontools_item_pages TO discussiontools_item_pages_temp; RENAME TABLE discussiontools_item_revisions TO discussiontools_item_revisions_temp; RENAME TABLE discussiontools_subscription TO discussiontools_subscription_temp;
- DROP TABLE discussiontools_items_temp; DROP TABLE discussiontools_item_ids_temp; DROP TABLE discussiontools_item_pages_temp; DROP TABLE discussiontools_item_revisions_temp; DROP TABLE discussiontools_subscription_temp;
- Where to run those changes: See above for the list of wikis
- When to run those changes: No particular rush
- If the schema change is backwards compatible: No, suggest renaming tables first and then dropping. However, the tables should not be accessed
- If the schema change has been tested already on some of the test/beta wikis: N/A
- If the data should be made available on the labs replicas and/or dumps: N/A