S
S
sailorpapay2018-09-26 15:16:50
MySQL
sailorpapay, 2018-09-26 15:16:50

What's taking up space on AWS RDS?

There is Mysql base on RDS.
100GB.

SELECT table_schema "DB Name",
Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;

tells us about 45GB in total.
But AWS says a different
Message : The free storage capacity for DB Instance: live-db is low at 2% of the provisioned storage [Provisioned Storage: 99.27 GB, Free Storage: 2.23 GB]. You may want to increase the provisioned storage to address this issue.
What can take up space?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Puma Thailand, 2018-09-26
@opium

Show the output of the command
Do you happen to have query logging enabled?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question