Re: [google-cloud-sql-discuss] Cloud SQL instance has massively inflated disk usage

We have not turned on any flags other than event_scheduler, so we're using the default value for that, which I believe should be off.

Cheers,

Kristian

On Wednesday, 15 May 2019 06:54:42 UTC+1, Pavel Ivanov wrote:

Do you have general log enabled on the instance by any chance?

Pavel

On Tue, May 7, 2019 at 10:24 AM Kristian Freed <kristi...@gmail.com> wrote:
>
> I have a 2nd generation MySql 5.6 cloud SQL instance running with binlog enabled and a failover replica.
>
> This has been in use steady state for some time, but recently I've noticed that the reported disk usage has gone up significantly. We have auto-increase enabled, but currently the disk usage reported in the cloud console is 8TB(!), whereas other tools, including the chart for "storage used" in cloud console report a much more sane 55GB.
>
> I've looked at binlogs and they're all manageable size.
>
> Is there any other reasons why the disk usage would be so massively inflated, and is there any way (other than re-creating the db from scratch) to force cloud sql to shrink it back down?
>
> Cheers,
> Kristian
>
> --
> 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/957d4155-6423-42f9-a74d-52f0d37958ea%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
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/dda9c04b-cce6-46c9-8b91-36a4b0c245b8%40googlegroups.com.