[google-cloud-sql-discuss] Runaway query increased our ssd storage to 2TB

Hi all,

A colleague ran a query remotely from his machine, and killed it. However, it continued to run over the weekend, and our Auto Storage enabled instance ballooned from 15GB to 2TB, due to temporary table(s). I killed the query successfully and seen `removing tmp table`.  I incorrectly assumed Auto Storage would shrink back to 15GB. I then read Auto Storage "Capacity cannot be decreased later" and "All increases are permanent". We only have ~1GB of data, how would you suggest we get storage back to 15GB (minimum I think) so we don't have to pay for storage we don't need?

Thanks for your time

--
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/b7ebc949-bb90-44a7-b0cc-befc1b8c1c37%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.