What will happen when AUTO_INVREMENT on an INTEGER column reaches MAX_VALUE in MySQL?

Once a column reaches the MAX_VALUE, the AUTO_INCREMENT stops working. It gives following error in log:

ERROR: 1467 (HY000): Failed to read auto-increment value from storage engine

Leave a Reply

Your email address will not be published. Required fields are marked *