- Le plus récent
- Le plus de votes
- La plupart des commentaires
Hi There
Amazon RDS DB instance storage is used by the following:
- Temporary tables or files that are created by PostgreSQL transactions
- Data files
- Write ahead logs (WAL logs)
- Replication slots
- DB logs (error files) that are retained for too long
- Other DB or Linux files that support the consistent state of the RDS DB instance
Check this article for some troubleshooting steps for figuring out where the increase is coming from.
https://aws.amazon.com/premiumsupport/knowledge-center/diskfull-error-rds-postgresql/
In my case, a PostgreSQL instance is currently increasing at the rate of about 1 GB every hour! For weeks it was ok, then I scaled up from 5 GB to 16 GB, it got full again in 24 hours, then I scaled up from 16 GB to 32 GB, and the storage space is filling up again! It seems to coincide with a DMS task that I set up and ran yesterday. To bve confirmed in CloudWatch. There is an interesting multi-factor investigation protocol there indeed: https://repost.aws/knowledge-center/diskfull-error-rds-postgresql
In particular, I released occupied storage space by dropping replication slots unused once DMS task stopped.
A well known AI has generated some SQL to show the respective storage space used per DB.
SELECT pg_database.datname AS database_name,
pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database
ORDER BY pg_database_size(pg_database.datname) DESC;
However, it turns out that none is responsible. The largest DB is about 300 MB, and the 3 others are about 8 MB. The bloating data clearly come from somewhere else... and I don't know where.
Contenus pertinents
- demandé il y a un an
- Réponse acceptéedemandé il y a un an
- demandé il y a un an
- demandé il y a 4 mois
- AWS OFFICIELA mis à jour il y a 10 mois
- AWS OFFICIELA mis à jour il y a 2 ans
I also just recently created a RDS MySql database. I haven't touched it besides creating it. and within a week it has almost reached the monthly free tier limit of 20gb of storage use.
I have 2 snapshots related to the DB which cannot be deleted for some reason but that's it.
Under monitoring it says the DB instance it self only takes up 110mb out of 200gb.
Only other snapshots are the public ones in which there are more than 50.. however these cannot be removed as they are owned by other users. I think it would be insane if they counted into the calculation of your private RDS space.