[14:59:59] <Reedy>	 Did dropping all those _old tables have a significant impact on the amount of disk space used across the mysql cluster?
[15:01:20] <jynus>	 nope
[15:01:30] <jynus>	 but table == descriptor == resources
[15:02:15] <jynus>	 also less operational overhead - it takes a second per table to upgrade mysql version
[15:02:45] <Reedy>	 Always nice to get tech debt cleaned up eventually :)
[15:02:58] <jynus>	 5000 tables per 150 hosts is a lot of times saved for me
[15:03:11] <Reedy>	 :)
[15:03:38] <jynus>	 it will also simplify table data checking
[15:03:41] <jynus>	 so all wins
[15:03:55] <Reedy>	 Was just flicking through some of the other drop tickets... Few more tables to go, but I suspect the net win of removing them isn't anywhere as wide as the _old tables
[15:04:17] <jynus>	 agree
[15:04:49] <jynus>	 but please note that a single table per wiki is 900 tables
[15:05:04] <Reedy>	 oh yeah, I'm quite well aware :)
[15:05:12] <jynus>	 :-)
[15:05:15] <Reedy>	 The other tickets don't have tables on every wiki etc
[15:05:22] <jynus>	 there are some
[15:05:28] <Reedy>	 so it's > 1 and < 900 etc
[15:06:23] <jynus>	 https://phabricator.wikimedia.org/T115982
[15:06:51] <jynus>	 that is 2500
[15:07:26] <jynus>	 also old tables nobody cares about are a vector for data leaks
[15:08:05] <jynus>	 I would really vote for properly archiving old wikis rather than keeping them on the same hosts, specially if they are small ones
[15:08:32] <Reedy>	 old in what sense? "deleted"? or just "closed"?
[15:08:56] <jynus>	 both, anything that doesn't require live querying
[15:09:04] <jynus>	 if closed means read only, they are active to me
[15:09:09] <Reedy>	 Yeah, it does
[15:09:17] <jynus>	 then, not those
[15:09:25] <Reedy>	 Deleted wikis should be good to be archived
[15:09:36] <Reedy>	 Some of those have been moved offsite etc
[15:09:43] <Reedy>	 I wonder if I can help elicit some answers about some of these tickets so you know you can go ahead with them...
[15:09:50] <jynus>	 but closed dbs should be maintaned in the same way
[15:10:19] <jynus>	 otherwise mediawiki is updated and they would fall behind
[15:11:39] <jynus>	 please do, you may know the history of some extensions better than some people
[15:12:31] <Reedy>	 Unfortunately, some of the authors, even still at the WMF aren't the most responsive on tickets
[15:12:35] <jynus>	 we should also make a rule to delete/archive tables for extensions discontinued - but obviouly those are the least maintened ones
[15:14:15] <jynus>	 well, I can relate- I have so many tons of todo, that if it is not breaking wikedia, it is not on my short-term list
[15:14:56] <jynus>	 the only reason I am looking at this is because due to the chain of blockers, it is blocking more important things
[15:34:35] <Reedy>	 If they're ready to go, can I move them to backlog from triage?
[15:40:29] <jynus>	 which one?
[15:42:07] <Reedy>	 https://phabricator.wikimedia.org/T54924 can just be done
[15:42:58] <Reedy>	 https://phabricator.wikimedia.org/T57676 too
[15:44:28] <Reedy>	 Hopefully, the AFT indexes and tables can all just go too...
[15:54:04] <Reedy>	 Which would mean 19 tables from enwiki
[16:24:12] <jynus>	 please ad a comment on the tickets saying that you are ok with it and add, if relevant, any involved people
[16:24:32] <jynus>	 I've added to the backlog
[16:24:36] <jynus>	 *them
[16:26:20] <Reedy>	 I'm doing the digging on the AFT sutff :)