This bug tracks obsolete or otherwise unneeded database tables on Wikimedia wikis that should be dropped.
URL: https://wikitech.wikimedia.org/wiki/Database_tables
See Also: T18660
Table | Extension/Source | Recom. contact | Status | Task | Notes |
---|---|---|---|---|---|
__wmf_checksums.ibd | pt-table-checksum | DBA | To remove | But they are created by DBAs every time data checks run | |
_image_new.ibd | pt-online-schema-change going wrong | DBA | Removed | T171429 | probably an alter table abandoned, drop where it exists |
arbcom1_vote.ibd | E:BoardVote | @tstarling | Keep | Data to be archived. Once done, this table can be dropped. | |
blob_orphans.ibd blob_tracking.ibd | trackBlobs.php | @tstarling | Removed | T59186 | "Tracking table for blob rows that aren't tracked by the text table" related to blob_tracking |
bv2009_edits.ibd | E:SecurePoll | @tstarling | To remove | These bv_*edits tables are intermediate data (edit counts) generated by SecurePoll CLI scripts. The voter lists generated from them are stored in securepoll_lists. Probably not worth archiving since they were generated from archived edit data. | |
bv2011_edits.ibd | E:SecurePoll | @tstarling | To remove | ||
bv2015_edits.ibd | E:SecurePoll | @tstarling | To remove | ||
click_tracking.ibd | E:Click_Tracking | ? | Removed | T115982 | Dep. of E:ArticleFeedback |
click_tracking_events.ibd | E:Click_Tracking | ? | Removed | T115982 | Dep. of E:ArticleFeedback |
click_tracking_user_properties | E:Click_Tracking | ? | Removed | T115982 | Dep. of E:ArticleFeedback |
cur.ibd | MW Core | @tstarling | Keep | Need to audit text, ar_text for HistoryBlobCurStub objects | |
edit_page_tracking.ibd | E:EditPageTracking | Removed | T57385 | ||
email_capture.ibd | E:Email_Capture | ? | Removed | T57676 | Dep. of E:ArticleFeedback |
ep_cas.ibd | E:EducationProgram | @JeroenDeDauw | Keep | Actively deployed | |
ep_instructors.ibd | E:EducationProgram | @JeroenDeDauw | Keep | Actively deployed | |
ep_oas.ibd | E:EducationProgram | @JeroenDeDauw | Keep | Actively deployed | |
ep_revisions.ibd | E:EducationProgram | @JeroenDeDauw | Keep | Actively deployed | |
exarchive.ibd | MW Core | ? | ? | (old copy of archive table?) | |
exrevision.ibd | MW Core | ? | ? | (old copy of revision table?) | |
filejournal.ibd | MW Core | @aaron | Removed | T51195 | aaron committed this back in rSVN113704: [FileBackend] - I guess Wikimedia isn't using it? |
flaggedimages.ibd | E:FlaggedRevs | @aaron | Removed | T290340 | |
flaggedrevs_stats.ibd | E:FlaggedRevs | @aaron | Removed | T289050 | |
flaggedrevs_stats2.ibd | E:FlaggedRevs | @aaron | Removed | T289050 | |
flaggedtemplates.ibd | E:FlaggedRevs | @aaron | |||
global_block_whitelist.ibd | E:GlobalBlocking | @Legoktm/@Glaisher | Keep | Actively used | |
hidden.ibd | E:Oversight | ? | This should theoretically be obsoleted by the removal of the Oversight extension in T34628, but let me double check. | ||
interwiki.ibd | MW Core (not used by WMF) | Keep | T169376 | Just truncate. (done) | |
job.ibd | MW Core (not used by WMF) | Keep | T169377 | Just truncate. (done) | |
l10n_cache.ibd | MW Core (not used WMF deployment) | Keep | T169375 | Just truncate. (done) | |
linkscc.ibd | MW Core (removed in 1.5) | @tstarling | Removed | T192056 | |
localisation.ibd | Extension:LocalisationUpdate (table removed) | Removed | T119811 | ||
localisation_file_hash.ibd | Extension:LocalisationUpdate (table removed) | Removed | T119811 | ||
long_run_profiling.ibd | MW Core | @tstarling | Removed | T194661 | @tstarling made this as a temporary copy of the profiling table |
mark_as_helpful.ibd | E:MarkAsHelpful | Removed | T151655 | ||
mathoid.ibd | E:Math | @Physikerwelt | To remove | Now stored in Restbase T74240: Remove PNG only rendering mode | |
moodbar_feedback.ibd | E:MoodBar | Removed | T153033 | Undeployed from WMF | |
moodbar_feedback_response | E:MoodBar | Removed | T153033 | Undeployed from WMF | |
msg_resource.ibd | MW Core (removed in 1.27) | Krinkle | Removed | T194663 | Removed from core per T113092 |
msg_resource_links.ibd | MW Core (removed in 1.27) | Krinkle | Removed | T194663 | Removed from core per T113092 |
old_growth.ibd | Removed | T115982 | |||
pagetriage_tags.ibd | E:PageTriage | Keep | Appears to be used, but only for look-ups. Could be migrated to a data/config file. | ||
pif_edits.ibd | ? | ||||
povwatch_log.ibd | E:PovWatch | Removed | T54924 | ||
povwatch_subscribers.ibd | E:PovWatch | Removed | T54924 | ||
pr_index.ibd | E:ProofreadPage | Keep | Table may exist on wikis that don't use Extension. Can be removed from those | ||
prefstats.ibd | E:PrefStats | Removed | T154490 | ||
prefswitch_survey.ibd | E:PrefSwitch | Removed | T173439 | ||
profiling | MW CoreMW (removed in 1.5) | @Reedy | To remove | T266125 | Old table removed: T231366 |
reader_feedback | E:ReaderFeedback | @Reedy | Removed | T174586 | |
reader_feedback_history | E:ReaderFeedback | @Reedy | Removed | T174586 | |
reader_feedback_pages | E:ReaderFeedback | @Reedy | Removed | T174586 | |
searchindex.ibd | MW Core (unused by WMF) | @demon | Keep | T167978 | Truncate only. (done) |
securepoll_cookie_match.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_elections.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_entity.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_lists.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_msgs.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_options.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_properties.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_questions.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_strike.ibd | E:SecurePoll | @tstarling | Keep | ||
securepoll_votes.ibd | E:SecurePoll | @tstarling | Keep | ||
site_identifiers.ibd | MW Core | Keep | Actively in use | ||
sites.ibd | MW Core | Keep | Actively in use | ||
tag_summary.ibd | MW Core | @Ladsgroup | To remove | T209525 | Deprecated, use change_tag instead |
transcache.ibd | MW Core (not used in WMF) | Keep | Core table, just truncate | ||
transcode.ibd | E:TimedMediaHandler | @brion | Keep | Actively used | |
updatelog.ibd | MW Core (not used in WMF) | @demon | Keep | T174804 | Core table, just truncate |
valid_tag.ibd | MW Core | @Ladsgroup | Removed | T212254 | This is in use by MW core for change tagging |
vote_log.ibd | E:BoardVote | @tstarling | Keep | Data will be archived, once done, it may be dropped. |