When looking into a question raised by User:Cabayi in my mailbox, I noticed global account vanishing only removes the user email address from the globaluser record, but not from the (many) individual user tables. For example:
[urbanecm@stat1008 ~]$ analytics-mysql centralauth mysql:research@dbstore1008.eqiad.wmnet [centralauth]> select gu_name, gu_email from globaluser where gu_name='Renamed user 28145919bd97ab8be70d27c2e463c510'; +-----------------------------------------------+----------+ | gu_name | gu_email | +-----------------------------------------------+----------+ | Renamed user 28145919bd97ab8be70d27c2e463c510 | | +-----------------------------------------------+----------+ 1 row in set (0.001 sec) mysql:research@dbstore1008.eqiad.wmnet [centralauth]> ^DBye [urbanecm@stat1008 ~]$ analytics-mysql jawiki mysql:research@dbstore1009.eqiad.wmnet [jawiki]> select user_name, user_email from user where user_name='Renamed user 28145919bd97ab8be70d27c2e463c510'; +-----------------------------------------------+----------------------------+ | user_name | user_email | +-----------------------------------------------+----------------------------+ | Renamed user 28145919bd97ab8be70d27c2e463c510 | (REDACTED, CONTAINS USER EMAIL) | +-----------------------------------------------+----------------------------+ 1 row in set (0.001 sec) mysql:research@dbstore1009.eqiad.wmnet [jawiki]>
This is potentially significant, because we indicate emails are no longer kept. Also, IIRC, the feature was internalized into MediaWiki to be able to meet account deletion defined by Google/Apple.