3 ms·
IIRC at least slashdot and twitter had to do some non trivial database migrations because they hit maximum value of some ID field.
by dfox 9y ago
IIRC at least slashdot and twitter had to do some non trivial database migrations because they hit maximum value of some ID field.
- mikeash 9y agoTwitter's was called the twitpocalypse and it was a pretty big deal at the time. I don't know how bad it was internally, but it hit a lot of third-party apps that stored tweet IDs in 32-bit integers. One interesting aspect of it was that Twitter realized what was going to happen in advance, and artificially pushed their IDs over the edge at a preplanned time so they could have as many people available as possible to work on any problems that appeared.
- MichaelGG 9y agoI think Instagram also recently (year?) passed the 31 or 32 bit mark, as some client lib I was using started failing.