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-discuss+unsubscribe@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.
No comments:
Post a Comment