Data Loss Caused by Table Rebuild Operations (ALTER/OPTIMIZE) in Specific MySQL Versions
Last updated:2025-12-24 16:09:19
Data Loss Caused by Table Rebuild Operations (ALTER/OPTIMIZE) in Specific MySQL Versions
Last updated: 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.
Fixed Kernel Version
MySQL 8.0 20230704.
Fixing Methods
Upgrade the kernel version to MySQL 8.0 20230704. For the operation method, see Upgrading the Kernel Minor Version.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback