Why Is Disk Space Not Released After the delete Command Is Run to Delete Table Data on an Instance in TencentDB for MySQL?
When you delete table data from instances by running the delete command, disk space is not released due to the mechanism of TencentDB for MySQL. To free up disk space, you need to perform operations for rebuilding tables. For details, see the following command.
OPTIMIZE TABLE ${table_name};
Note:
If the table to be deleted is an InnoDB table, run the following command to release disk space.
ALTER TABLE ${table_name} ENGINE=INNODB;