FIVE WHYs ANALYSIS: Why did tags stop working? Tag ID hit a limit Why did it hit a limit? It was an INT column Why was it an INT? I am a careless and don't follow through enough Why am I so careless? Lonely childhood; ate paint chips Why so lonely? Vast, empty universe; no God
-
-
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
will it though
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Switching the index from int to bigint?
-
Lol, just checked an important data table a work and we're a couple months from the same problem.
End of conversation
New conversation -
-
-
This Tweet is unavailable.
-
at a few billion rows? Nah. Worry about sharding when your DB breaks into (or beyond) hundreds of terabytes, not before.
End of conversation
-
-
-
2B tags ought to be enough for anybody.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Obligatory NoSQL anywayism.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
I did that on a "followers" table :| pt-online-schema-change is solid if you're just increasing the type. Not smart about load, but I've used it a bunch. As long as load isn't super sensitive it's fine.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
