I have an AWS RDS - MySQL instance, and it has one database.
Instance Class: db.r6g.xlarge Engine version 8.0.17 Storage: 100 GB
The database size is only 24GB, but the AWS console shows only a free space of 8GB. I can't find out what is consuming this 92GB of space, even though the DB size is only around 25GB,
The output of the following command gave me the DB size in GB.
SELECT table_schema, ROUND(SUM(data_length+index_length)/1024/1024/1024,2) "size in GB" FROM information_schema.tables GROUP BY 1 ORDER BY 2 DESC;
Output of SHOW MASTER LOGS;
Ouput of select table_name, round(data_length/1024/1024) as data_length_mb, round(data_free/1024/1024) as data_free_mb from information_schema.tables where round(data_free/1024/1024) > 250 order by data_free_mb;
Any help to find out what is consuming the rest of the storage space would be really helpful?