Mysql table ends with identifiers

Question

We have a mysql table, which soon ends with identifiers (the main identifier is a 32-bit integer, and max id is about 1.5 billion). What is the best way to solve this problem? Change the id type to 64-bit, but this will lead to database failure for too long, because the table has a billion rows.

Answer 1

All versions of MYSQL (both 32-bit and 64-bit) use an 8-byte field for a column defined as BIGINT.

So change the BIGINT column

Check Documentation

Answer 2

then try changing the type of field. Try using some type with a large range, such as " BIGINT ".