Data Loss Caused by Table Rebuild Operations (ALTER/OPTIMIZE) in Specific MySQL Versions
フォーカスモード
フォントサイズ
最終更新日: 2025-12-24 16:09:19
Issue
Table rebuild operations (ALTER/OPTIMIZE) in specific MySQL versions cause data loss.
Issue Triggering Scenarios
In MySQL 8.0.30, performing table rebuild operations (ALTER TABLE TABLE_NAME ENGINE=INNODB and OPTIMIZE TABLE) may lead to data loss. For more information, see the MySQL official documentation: MySQL Bugs: #115608 and MySQL Bugs: #113812.
Affected Kernel Versions
In TencentDB for MySQL, the kernel versions affected by this issue range from MySQL 8.0 20221215 (inclusive) to MySQL 8.0 20230703 (inclusive). You can query and check whether your database instance falls within this range.