Hopefully you don't have an auto-increment int (2^31) as a PK, or you'll be worr... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

spudlyo on June 6, 2012 | parent | context | favorite | on: Loading half a billion rows into MySQL

Hopefully you don't have an auto-increment int (2^31) as a PK, or you'll be worrying sooner than you think.

rs on June 6, 2012 | [–]

That'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

Cyndre on June 9, 2012 | | [–]

That is interesting to know, I have been setting my index's to bigint for a long time.

jpitz on June 6, 2012 | [–]

Ugh. No. This uses a multi-column natural key. I have a tendency to avoid synthetic keys when I can.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact