How to free up space on your Amazon RDS MySQL instance
We are using an Amazon RDS instance and it ran out of storage space. After examining the problem, we dropped the unnecessary table. Amazon's monitoring tool revealed that 1GB of space is now available.
Further investigation showed that the other table had 7 million records, so we deleted 5 million of them (using a simple delete command). However, now the free storage space has dropped to almost 1/2 GB. We're dangerously close to drying out again.
I (naively) assumed that deleting records from the table would free up space. Why is it wrong? Do I need to perform any manual cleaning operation? Why doing the delete used up almost 1/2 GB of free space (looking at the 2677 MB table before the delete and now 2961 MB!)
Thank,
Phil
source to share
You may have unused indexes in your database that might be taking up space. Percona makes tools and fixes for MySQL to collect index usage data.
Check out these links:
You can also look at them:
- New table_io_waits_summary_by_index_usage in performance_schema file in MySQL 5.6
- New INDEX_STATISTICS table in information_schema
I recommend using the performance schema when using MySQL 5.6 or higher. Also you can take a look at MONYOG-Mysql Monitoring . It includes tools for monitoring various performance metrics of MySQL server, there is a disk information function that can help you with this problem.
source to share