How to Free MySQL Table Space

1 year ago
Sophia Anderson
1 minute

In MySQL, the way to release table space is to rebuild the table using the ALTER TABLE statement. The specific steps are as follows:

  1. Execute the following query to view the table’s storage engine and table space size:
SHOW TABLE STATUS LIKE 'table_name';
  1. If the storage engine of the table is InnoDB and the table occupies a large amount of space, you can use the following command to release table space:
ALTER TABLE table_name ENGINE=InnoDB;
  1. Rebuilding a table will recreate the table and free up previously occupied space, reducing the table’s space usage.

It is important to note that rebuilding a table may result in the loss of table data, so be sure to backup the table data before performing this operation.

bannerAds