#wikimedia-office: RFC meeting

Meeting summary

1. RFC: Unify various deletion systems (TimStarling, 21:00:58)
   1. - https://phabricator.wikimedia.org/T198156 -- wrt the unification of deletion systems, not sure if that would be related (Hauskatze, 21:26:38)
   2. <TimStarling> you can either have table scanning, or strikethrough, or have an additional index (user,deleted,timestamp) (Krinkle, 21:31:03)
   3. Krinkle says hiding revisions from Special:Contributions (not just strikethrough) is a hard requirement (TimStarling, 21:44:46)
   4. There's also a need for selective deletion or some equivalent feature such as history splitting to clean up action=history on heavily vandalised pages (TimStarling, 21:45:44)
   5. for contributions, it's unclear whether table scanning or an additional index is optimal for performance: CPU/memory tradeoff (TimStarling, 21:47:45)
   6. third query plan option for contributions is tgr's idea of (user,deleted,timestamp) and have deleted IN(0,1) for unified views (TimStarling, 21:49:48)
   7. title table can be done first and separately (TimStarling, 21:59:47)
   8. perhaps possible to have deleted pages in the page table, with (page_deleted,page_title_id) index (TimStarling, 22:00:56)
   9. Without additional care, manual history merge via undelete might stop if no longer title based but page_id based. To be fixed by either continuing to be title based (using page_archive, or non-unique page_title), or by requiring use of Special:MergeHistory and updating that to do rev_page updates instead of delete/move/undelete. (Krinkle, 22:01:07)
   10. current selective deletion use case (hiding things from history) could be done by creating a new deleted page and moving selected revisions into it (TimStarling, 22:02:18)

Action items

1. (none)

People present (lines said)

1. Krinkle (62)
2. TimStarling (45)
3. tgr (11)
4. legoktm (8)
5. bawolff (5)
6. Regenpfeifer (3)
7. wm-labs-meetbot` (3)
8. Hauskatze (2)
9. stashbot (2)