|Open||None||T18660 Database table cleanup (tracking)|
|Open||None||T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking)|
|Resolved||jcrespo||T115711 Drop `user_daily_contribs` table from all production wikis|
According to https://gerrit.wikimedia.org/r/#/c/246689/1/wmf-config/InitialiseSettings.php, this should have been enabled on all production wikis.
About to perform a rename of the table to delete_user_daily_contribs on all wikis to verify that it is indeed not used anymore.
There are 30 million rows on these tables (on enwiki, fewer on the others). This makes this a slightly more complex issue due to potential impact on the 5.5 masters. We will have to do it slowly, specially for s1 and s3.
I will also create a backup first.
I have renamed the table on all wikis to delete_user_daily_contribs; I will leave it as is for some time, will delete it afterwards after checking that no code is requiring it.
A backup exists for all tables on iron.
@ori, I do not know that you did here, but you did not delete the views:
mysql -BN -A -h labsdb1001.eqiad.wmnet enwiki_p -e "SHOW TABLES like '%user_daily_contribs%'" user_daily_contribs
, or modified the script that creates it:
Reopening and putting it on my backlog.
Sigh. This has to do with my pathological tendency to confuse labs with beta cluster. I dropped the tables on the beta cluster. Which is not what you were actually asking about, I now realize.
Finally, I have deleted all tables and view referencing this table and I am ready to close.
One last thing, @ori, I saw the table bing recreated on vewikimedia production. Can you make sure references to that table on code are vanished and it is not recreated? I assume it was a "human race condition", by which it was recreated while it was being deleted and I had an old copy of dblists, but can you check the fact (the table will not be recreated in the future)?