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

Hi,

Thank you for your reply. We did have a couple of on demand backups and I have now deleted most of them but with no impact on the disk usage reporting. The number I'm looking at is "SSD storage" in the instance details view in the Google Cloud Console, as can be seen in https://drive.google.com/file/d/1f9sQrqhM3_5QXPkL1z8VDP5_s1SluhBn/view?usp=sharing

Would this number include backups?

I have confirmed that general_log is off when using show variables.

Any other pointers would be much appreciated as we're now paying for the very inflated number every month and I cannot see a reason why.

Cheers,

Kristian

On Wednesday, 15 May 2019 19:20:31 UTC+1, Sam (Google Cloud Support) wrote:

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/7ef5df04-6d6a-410b-bbc2-ca198668ad5e%40googlegroups.com.