CODEWITHSUNDEEP
google-cloud-sql
danemacmillan
danemacmillan

Reputation: 1242

Size of SQL disk storage space growing 32GB a day

Since April 1st, the size of my DB storage space grows by 32GB a day. It's very unusual, and based on the 500GB disk, this will not last for much longer.

Why is the DB growing by 32GB a day?

For context, I've allocated a 500GB disk; binary logs are enabled; automated backups are enabled.

enter image description here

Upvotes: 0

Views: 308

Answers (2)

danemacmillan
danemacmillan

Reputation: 1242

I tested further. The reason for the DB growing so dramatically every night is due to the binary logs. Every night Magento indexes run, and produce 32GB of binary logging data. Not all Magento stores will be the same, but large Magento stores beware.

The solution, temporarily at least, is to disable binary logging. Have a look at the image to see the reclaimed disk space after disabling the option.

This will make it a challenge when setting up read/failover replicas. It would be nice if the MySQL instance is configured to purge/prune binary logs after a set amount of time has passed, or at least once operations have been copied to slave instances. Maybe it does, but I haven't investigated. Given current time constraints, I was not going to wait until the purge/prune happened, if it even would.

enter image description here

Upvotes: 1

Adam Nunez
Adam Nunez

Reputation: 46

Could it be your DB log that is growing at a rapid pace?

I have had this issue in the past and ended up creating a job for the SQL agent that runs once a week and purges the log.

Upvotes: 0

Related Questions