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.

posta 2 anni fa631 visualizzazioni
1 Risposta
0
Risposta accettata

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
TECNICO DI SUPPORTO
Kevin_Z
con risposta 2 anni fa
  • Hi Kevin_Z, I will check it. Thank you for your support.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande