CloudSQL Instance size issue.

[Rajendra More]

Hello All,

We have a 2nd generation  MySQL 5.7  database instance with HA, In last few day's SQL instance storage size is increasing. Total database size is 28GB, but currently storage size more than 70 GB. Have anyone faced this type of issue.

We have enabled "slow_query_log" and "log_output" flags. 

Thank you,

[ocando]

The issue might have to do with the way you configured the "log_output" flag. As described here [1] it is recommended to use FILE (as if you have set the flag to "TABLE" the table created might become very large and affect your database). Another usual suspect for increased Storage that is not related to your data might have to do with the binary logging. 

Either case. I'd strongly advise you to contact support [2] and if you've purchased a support plan to create a support case [3]. As this will not be the correct place to share your project name or any data about your Cloud SQL instance,

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

[2] https://cloud.google.com/support-hub

[3] https://cloud.google.com/support/docs/manage-cases#creating_cases

[Rajendra More]

We have set the ""log_output = FILE" flag and binary logging is on for this instance because it is in  "Auto Backup" and "Point in time recovery" mode.
This issue might be because of binary logging, but I read that old binary logs are removed after every daily auto backup, Is it true ? If it is true then binary log size must be low.

--

Rajendra More

IT Infrastructure Manager

P +91-(976) 433-5755

www.smartscm.com

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/195dc379-aeb1-4886-a972-9ec5704dbb16n%40googlegroups.com.

[Rajat Gupta]

Enabling the PITR shoots the db storage exponentially based on the traffic on the database. 

Also, might scale up the storage allocation of the instance which cannot be reduced at a later stage.

[methkal]

Either case. I'd strongly advise you to contact support [1] and if you've purchased a support plan to create a support case [2]. As this will not be the correct place to share your project name or any data about your Cloud SQL instance for further investigation. 

[1] https://cloud.google.com/support-hub

[2] https://cloud.google.com/support/docs/manage-cases#creating_cases