Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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...



I wonder what they use to generate IDs! /s

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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: