通过删除不必要的数据优化Aurora MySQL存储
原文英文,约500词,阅读约需2分钟。发表于: 。A table in our Aurora MySQL database was consuming approximately 80% (around 400 GB) of the total storage. Since we were able to archive older data as CSV files, we decided to delete old records...
一张Aurora MySQL数据库表占用总存储的80%(约400 GB),为了释放存储空间,删除旧记录后发现释放存储空间比预期复杂。使用SELECT语句查询表和数据库的存储使用情况。释放数据库存储的步骤包括删除旧记录、更改实例类别和运行OPTIMIZE TABLE命令。注意使用OPTIMIZE TABLE命令时需要考虑锁表的问题。