0

im saving chat messages in MYSQL and set the ID for each message as an BIGINT AutoIncriment is it wrong? is the BIGINT gonna be enough, and what the solution if we reach the maximum number for BIGIN value?

Zeone line
  • 205
  • 4
  • 13
  • 1
    How many chat messages will you insert per second? Do you increment the ID by 1 each time? Did you start the ID at 1? If so, you will not run out of a BIGINT before the sun explodes. – Bill Karwin Nov 23 '20 at 19:24
  • thanks someone edited the question and give a good link – Zeone line Nov 25 '20 at 12:08

0 Answers0