Tuesday, February 18, 2020

Re: [google-cloud-sql-discuss] Re: Space usage for Transaction Log file is near to 0%, Performance tests on GKE with CloudSQL show high wait times for transaction log iops .

Hi Kenny, 

As you rightfully point out, this is a managed environment, so Windows admin logins are not supported. All user accessible settings are listed on the "Instance settings" page. These settings are not entirely without interest. It's true, there is no apparent way to shrink transaction log files, but you may consider setting "Automatic storage increase" to off, and set the "Automatic storage increase limit" parameter, to limit storage use, if this were of interest in this context. 

You can set database flags as well, as detailed on the "Configuring database flags" documentation page

--
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/1a41652a-c94e-4b66-95d4-ce56f855e8bb%40googlegroups.com.

No comments:

Post a Comment