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;
Can Storage Space Be Directly Scaled Out? Is Data Migration Required? What Is the Impact of Scaling Out?
Storage space can be scaled out directly. If the storage space on the host where the instance resides is insufficient, the system migrates the instance data from the current host to a new host and synchronizes the original instance data.
How Is Scale-out Billed?
How to Troubleshoot a Sudden Increase in Storage Space Usage?
1. Log in to the TencentDB for MySQL console. In the instance list, click the Instance ID or Manage in the Operation column to go to the instance management page. 2. You can view the disk space usage of each file in Instance Details > Resource Usage > Disk Usage, which helps identify the specific category causing a sudden increase in disk usage. You can also view disk-related monitoring metric fluctuation charts on the instance monitoring page, and use the disk space usage within a specified time range to troubleshoot the main events and operations performed by your business during that period.
How to Delete Files to Free Up Space?
Why Does a Newly Created Database with No Data Already Have Disk Usage?
After a database is created, related system tables are created to store accounts, permissions, and other information. In addition, logs of the database system (such as Redo logs) also occupy disk space.
Does the Storage Space of a TencentDB for MySQL Instance Include Backup Space?
The disk usage statistic in Resource Usage Statistics on the instance details page of the TencentDB for MySQL console represents only the instance space and does not include backup space. To query backup space usage, go to the Database Backup page. How Long Does It Usually Take for a TencentDB for MySQL Instance to Enter the Locked State After Its Storage Space Is Full? What Should Be Done Once It Enters the Locked State?
When the instance storage space is full, the instance enters a pre-locked state. It can continue to read and write within 24 hours, and enters a locked state after 24 hours in the pre-locked state. Due to the system inspection mechanism, there may be a delay in the change of the instance state.
Once an instance is locked, data cannot be written to it. We recommend that you set event alarms to prevent the instance from being locked due to full storage space. In addition, you can check the storage space regularly and scale out the instance in a timely manner when storage space is insufficient.