A colleague ran a query remotely from his machine, and then killed it. However, it continued to run on the server over the weekend, increasing storage from 15GB to 2TB!! I then killed the query, and seen `removing tmp table`. I incorrectly assumed our storage would shrink back down after deletion of the temporary table, but storage is still at 2TB. Our data is only ~1GB, so what's the best way to get storage back down and not pay for 2TB?
-- Thank you 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/e63b29ef-4b0d-4e58-ab46-598e9da42faa%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment