3 ms·
Hopefully you don't have an auto-increment int (2^31) as a PK, or you'll be worrying sooner than you think.
by spudlyo 14y ago
Hopefully you don't have an auto-increment int (2^31) as a PK, or you'll be worrying sooner than you think.
- rs 14y agoThat's one reason why switching auto-increments to bigint does help (a lot): http://dev.mysql.com/doc/refman/5.5/en/integer-types.html http://dev.mysql.com/doc/refman/5.5/en/integer-types.html
- Cyndre 14y agoThat is interesting to know, I have been setting my index's to bigint for a long time.
- jpitz 14y agoUgh. No. This uses a multi-column natural key. I have a tendency to avoid synthetic keys when I can.