Overview
This article describes whether deleting an index from InnoDB using the drop Command releases the disk space.
Background information
Alibaba Cloud reminds you that:
- When you perform operations that have risks, such as modifying instance configurations or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
Because the index and data are stored in the same file, InnoDB deletes the index using the drop command without releasing the disk space.
Application scope
-
ApsaraDB RDS for MySQL