tencent cloud

TencentDB for MySQL

DocumentationTencentDB for MySQLKernel FeaturesChecking and Fixing Kernel IssuesData Loss Caused by Table Rebuild Operations (ALTER/OPTIMIZE) in Specific MySQL Versions

Data Loss Caused by Table Rebuild Operations (ALTER/OPTIMIZE) in Specific MySQL Versions

PDF
Focus Mode
Font Size
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.
Previous Topic: Crash Caused by a Redo Buffer Calculation Defect in Instant CHANGE COLUMNNext Topic: Instant DDL Cannot Properly Handle Column Name Case Inconsistency

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback