Space usage for Transaction Log file is near to 0%, Performance tests on GKE with CloudSQL show high wait times for transaction log iops .

[kenny]

Hi,

Seems that user does not have permission to monitor logs and or shrink the file size as its a managed service.

• Space usage for Transaction Log file is near to 0%, we need to shrink these to get better performance for both database instance & tempdb, don't seem to have required permissions ?

• How do we shrink transaction log files when required ? , how do we manage such operations, are there any alternate ways (or) do we have any other user in CloudSQL similar to sa ? to carry out such operations

PFA for reference and help advise with the necessary steps/actions.

[George (Cloud Platform Support)]

Hello Kenny, 

You are right, this is a managed environment. You may consider using the standard MySQL mysqlbinlog utility to examine the transaction logs, if you have prior to that enabled binary logging for you instance, and configured an IP address. 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching App Engine and Cloud SQL. For setting up and configuring MySQL instances, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

[kenny]

Hello George,

I am looking for SQL Server Cloud SQL,                                                                                                                

is there a way i can login as windows admin (or) create a login with required permissions to execute DBCC commands such as shrink file/database ?

--
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/8b58ef09-e071-4fcf-81cf-bef7869abf8f%40googlegroups.com.

[George (Cloud Platform Support)]

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.