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

Hey Kristian,

You can view current values of database flags by issuing 'SHOW VARIABLES;' statement once logged into your instance with the mysql client to view all current values of the MySQL system variables [1]. What is the value of the 'general_log' flag [2]? If it's enabled, that could mean that it is contributing to the disk usage.

Aside from that, it's very important to note that if you use on-demand backup (create a backup at any time) this could impact your disk usage and billing charges in the long-term. Because you can create on-demand backups for any Second Generation instance, whether the instance has automatic backups enabled or not, on-demand backups are not automatically deleted the way automated backups are. They persist until you delete them or until their instance is deleted. 

That being said, as they are not automatically deleted, on-demand backups can have a long-term effect on storage and your billing charges if you do not delete them. Could this be what you are noticing? More on on-demand backups here [3].

Hope this helps decipher what's going on with disk usage. If this doesn't quite address your issue, then providing some screenshots from the tools you are using and from the Cloud Console and we can investigate further, and if this is an issue with the instance then we can create a Public Issue Tracker for further troubleshooting using the details your provide.

Thank you! 

[1] https://cloud.google.com/sql/docs/mysql/flags#viewing_current_values_of_database_flags

[2] https://cloud.google.com/sql/docs/mysql/flags#mysql-g

[3] https://cloud.google.com/sql/docs/mysql/backup-recovery/backups#about_on-demand_backups

--
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/708b2a44-94c3-49cf-915d-f99be488f193%40googlegroups.com.