Carson Reinke's (🚗☀☔🔑) Blog

Optimize MySQL ARCHIVE Table

Running optimize on an archive table will reset the AUTO_INCREMENT value.  Setting the AUTO_INCREMENT value back to the original value will not work, instead this needs to be set to 0 or 1.  Appears to be something how the table is re-built, might be a problem specifically with using partitions also.

mysql