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.

demandé il y a 2 ans632 vues
1 réponse
0
Réponse acceptée

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
INGÉNIEUR EN ASSISTANCE TECHNIQUE
Kevin_Z
répondu il y a 2 ans
  • Hi Kevin_Z, I will check it. Thank you for your support.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions