The maximum value of the Integer data type is 2 billion 147 million. How much is there, what if the record table has more than this number?

Question

Database design

For example, we have a mysql database, it has a table with comments, in which there is a field
id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, at one point the 2,147,483,647th comment is written there, what happens next when you try to write another comment? And most importantly, what to do with the base in this case? Let's omit the option with deleting old comments.
ps for those who do not understand the meaning - the integer type takes a value from -2,147,483,648 to +2,147,483,647
In principle, the theoretical answer is also interesting, but I would like to hear the answer of those who have already encountered this, so to speak, live, in practice.

Answer 1

I'm not sure if mysql will live to this extent, but all normal people for id usually use unsigned values ​​or 32 or 64 bits as needed.

Answer 2

If you need sky-high table sizes, then you can use a composite key.