[google-cloud-sql-discuss] Re: How do i know why I am using so much Storage ?

It is possible to get the size of the binlogs in order to see if that's the issue. On MySQL it can be done with SHOW BINARY LOGS [1], for more information on how to manage and view your binary logs and storage for a CloudSQL instance, see [2] and for more information on the impact and the effects of binary logging on your CloudSQL instance storage, please see [3].

[1] https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html

[2]https://cloud.google.com/sql/docs/mysql/instance-info#available_metrics

[3] https://cloud.google.com/sql/docs/mysql/replication/tips#bin-log-impact

On Wednesday, August 22, 2018 at 10:43:35 AM UTC-4, Kasandra Padisha wrote:

Hi

I have a set of databases that are about 64G in size but my Cloud SQL Storage Usage shows around 768 Gb and growing.

I have also a failover database and it only shows 84Gb.

My Question is:  How do i know why I am using so much Storage ?  I know it can be backups or binlogs but there is no place to check that out.

Could you help me ?

Cheers

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/215bb768-e92b-429a-84f9-d334abeca9dd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.