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

Read the full book at www.amazon.com
Posted in MySQL, MySQL Interview Questions

Leave a Reply

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