4 ms·
I once worked for a company that maxed out a 32 bit autoincrement primary key on a mysql table. Relational databases can hold a lot more than people give them
by kod 8y ago
I once worked for a company that maxed out a 32 bit autoincrement primary key on a mysql table. Relational databases can hold a lot more than people give them credit for.
- icedchai 8y agoYep. I worked at a company that had to migrate to 64-bit IDs. This was with MySQL 5.0 on servers with HDs, not SSD. Some of those "alter table" commands took all night!
- pickle-wizard 8y agoOh man, I hope they saw that one coming ahead of time.
- erik_seaberg 8y agoA colleague describes this problem as "running out of numbers".