3 ms·
My telemetry table is >2B rows and growing. 5B is starting to worry me; .5B, not so much. This is even backed by ( not much ) spinning rust.
by jpitz 14y ago
My telemetry table is >2B rows and growing. 5B is starting to worry me; .5B, not so much. This is even backed by ( not much ) spinning rust.
- spudlyo 14y agoHopefully 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.