Re: [google-cloud-sql-discuss] Re: CloudSQL Instance size issue.

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

On Thursday, January 21, 2021 at 5:59:47 PM UTC+1 rajat....@telusinternational.com wrote:

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.

On Thursday, 21 January, 2021 at 9:15:39 pm UTC+5:30 Rajendra More wrote:

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

On Thu, Jan 21, 2021 at 2:23 PM 'ocando' via Google Cloud SQL discuss <google-cloud...@googlegroups.com> wrote:

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

On Wednesday, January 20, 2021 at 9:11:16 AM UTC+1 Rajendra More wrote:

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,

--
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.

--
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/9cd38200-ca7d-435b-8646-1bf90e7c4dbdn%40googlegroups.com.