[go: up one dir, main page]
Page MenuHomePhabricator
Create Task
Maniphest T266125

Drop table profiling from WMF wiki mariadb servers
Closed, ResolvedPublic
Actions

Description

As far as DBA s have been told, this was an old table of mediawiki core dropped in MW 1.35:

While the task was resolved, data was not removed from production. This is particularly interesting, because any data would have been lost as I belive it was created with the memory engine (data lost on every restart).

This has been brought to my attention while running CHECK TABLES on source backup hosts (T265866), as those tables on the MEMORY/HEAP engine cannot be checked.

Removal progress:

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7 (not present there)
  • s8
  • s10 (wikitech)
  • labtestwiki (not present there)

Related Objects
Search...

Event Timeline

jcrespo created this task.Oct 21 2020, 1:07 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 21 2020, 1:07 PM
jcrespo triaged this task as Medium priority.Oct 21 2020, 1:08 PM

I will take care of dropping it first on the source backups so those don't contaminate other host, other host will have to wait until dc switchback from codfw to eqiad.

I am going to triage it as medium for the source backups, low for the rest.

jcrespo mentioned this in T54921: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking).Oct 21 2020, 1:10 PM
jcrespo added a parent task: T265866: Run check table periodically on backup source hosts.
• Marostegui moved this task from Triage to Ready on the DBA board.Oct 22 2020, 7:15 AM
• Marostegui updated the task description. (Show Details)Dec 22 2020, 9:12 AM
• Marostegui updated the task description. (Show Details)Dec 22 2020, 9:16 AM
• Marostegui claimed this task.Dec 23 2020, 6:50 AM

I will take care of this after the holidays

• Marostegui moved this task from Ready to In progress on the DBA board.Jan 4 2021, 6:56 AM
• Marostegui updated the task description. (Show Details)
• Marostegui updated the task description. (Show Details)Jan 4 2021, 7:10 AM
• Marostegui updated the task description. (Show Details)Jan 4 2021, 7:17 AM
• Marostegui updated the task description. (Show Details)Jan 4 2021, 7:49 AM
• Marostegui updated the task description. (Show Details)
• Marostegui updated the task description. (Show Details)Jan 4 2021, 8:39 AM
• Marostegui updated the task description. (Show Details)
• Marostegui updated the task description. (Show Details)
LSobanski subscribed.Jan 4 2021, 8:40 AM
• Marostegui added a comment.Jan 4 2021, 8:41 AM

On s3 it is only present on:

+--------------+
| table_schema |
+--------------+
| aawiki       |
| testwiki     |
+--------------+
2 rows in set (0.051 sec)
• Marostegui closed this task as Resolved.Jan 4 2021, 8:42 AM
• Marostegui updated the task description. (Show Details)

This is completed

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits