17

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.

Thanksenter image description here

Improve this question
3
  • Do you mean that you only see 160MB when using query from here: stackoverflow.com/questions/1733507/… Commented Apr 19, 2017 at 17:48
  • Yes its coming of size 352 MB with sql query. Commented Apr 20, 2017 at 4:53
  • @Rupeshkumar finally the problem was what was said by Vadim? Commented Apr 22, 2019 at 17:10

2 Answers 2

Reset to default
4

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Hey Vadim, I'm having the same issues and I was wondering if there is a way to confirm that its the binary logs with the sql command at all? Thanks
I am having the same issue. After executing SHOW BINARY LOGS; in phpmyadmin, the MySQL said "#1381 - You are not using binary logging". So I guess for my case it's not due to binary logs? Any other possible reason or how can I check the cause?
1

Possibly you are enabling general_log option. Check EDIT -> Cloud SQL flags -> general_log. If this is on, turn it to off.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.