Why BIGINT Keys Won't Run Out Even as a Database Reaches 1 TB
A growing events platform called Matoo reached a 1 TB database, prompting developers to question whether its BIGINT(20) primary keys could eventually be exhausted. The article explains that the (20) in MySQL is only a display-width setting, while the type still uses eight bytes and supports values up to about 9.2 quintillion. Even at one million new IDs per second, exhausting that range would take roughly 292 thousand years. The more pressing concerns are storage overhead from indexes and maintaining query speed as tables grow to hundreds of millions of records.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.


Discussion (0)
Log in to join the discussion and vote.
Log in