对于InnoDB，truncate会重置auto_increment的值为1。 delete后表仍然保持auto_increment。 但是在做delete整个表之后重启MySQL的话，则重启后的auto_increment会被置为1。

MySQL Autopilot uses advanced machine learning techniques to accelerate HeatWave query performance and scalability in Oracle Cloud’s MySQL Database Service.

The MySQL Heatwave Lakehouse changes that paradigm, enabling the database to query data that is stored in cloud object storage, commonly referred to as a data lake.