RDS MariaDB size actual more than usage.

0

Hi Everyone, I have used RDS MariaDB with the option Autoscaling enable. I receive alarm feeble storage of more than 120GB. But actually, I did check size storage in Databases is 54GB with the command below:

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size in GB" 
FROM information_schema.tables 
GROUP BY table_schema; 

Please explain and help me resolve issues. Best regard.

asked 2 years ago617 views
1 Answer
0
Accepted Answer

Hi,

I would suggest using below links to analyze the database storage consumption in details and see if there are any further info can be found.

https://aws.amazon.com/premiumsupport/knowledge-center/view-storage-rds-mysql-mariadb/ https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-storage-optimization/

If still not able to identify the root cause, if you have support plan, I would suggest raise a support case to have us look into the instance.

AWS
SUPPORT ENGINEER
Kevin_Z
answered 2 years ago
  • Hi Kevin_Z, I will check it. Thank you for your support.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions