Google Cloud SQL Storage Usage High Issue

Question

We have Setup Cloud SQL in google cloud with configuration of Tier db-n1-standard-4 with storage of 100GB SSD. My actual database size is having only 160MB Max but in Cloud Cloud SQL instances it showing up to 72GB used i don't know why? and its still increasing per day about 10GB. Can anyone explain about this issue.

Thanks

Answer 1

Most of the time this is due to binary logs that are used for replication. The growth of binary logs is roughly proportional to the amount of modified rows.

Binary logs are purged after 7 days so the space will stabilize after 7 days.