Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
AWS re:Postre:Post

RDS Storage full with 1.6TB storage while the DB is only 20 GB

0

My databases in total size are 20 GB. But the RDS instance had a storage full error and enabling auto scaling it went to 1.6 TB.

20 GB vs 1.6 TB is crazy. I have looked at logs, double checked DB size etc. but cannot find any usual suspects. Is there a process to identify the culprit?

  • Adeleke Adebowale J EXPERTO
    hace 2 meses

    can you check the CloudWatch metrics for your RDS instance to understand the pattern of storage growth. Look for sudden spikes or abnormal patterns that coincide with the increase in storage

Temas
Base de datos
Etiquetas
Base de datosMySQL
Idioma
English
recurpost
preguntada hace 2 meses173 visualizaciones
1 Respuesta
1

Is this RDS PostgreSQL or MySQL?

For PostgreSQL, the VACUUM command can be used to remove dead tuples which occupy disk space. Refer to Understanding autovacuum in Amazon RDS for PostgreSQL environments for more information.

After that, you may want to restore database snapshot to a new RDS instance.

AWS
EXPERTO
Mike_L
respondido hace 2 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante