Even years later, Twitter doesn’t delete direct messages

Re:Even years later, Twitter doesn’t delete direct messages by spudlyo on Friday February 15, 2019 @08:28PM (#19176389)

Your instincts are correct. I happen to know that DMs at Twitter are (and most likely still) stored in a sharded MySQL store[0]. Deleted DMs and tweets are "tombstoned", and not actually deleted via a DELETE, which has pretty terrible performance characteristics in MySQL

[0]: http://highscalability.com/blog/2011/12/19/how-twitter-store...

[ Parent | on HN ]

Re:Even years later, Twitter doesn’t delete direct messages by Operyl on Friday February 15, 2019 @09:04PM (#19176532)

I wonder what they use to generate IDs! /s

Man that comment popped up a bunch in that blog post, lol.

[ Parent | on HN ]