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.

gefragt vor 2 Jahren632 Aufrufe
1 Antwort
0
Akzeptierte Antwort

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-TECHNIKER
Kevin_Z
beantwortet vor 2 Jahren
  • Hi Kevin_Z, I will check it. Thank you for your support.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen