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

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.

Confidentiality Notice: 

This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain confidential information that is legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender. Please destroy the original transmission and its attachments without reading or saving in any manner.

--
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/2aaf20ae-02cc-4b21-b538-b6360683aa0en%40googlegroups.com.