Tuesday, February 22, 2022

[google-cloud-sql-discuss] Re: maintenance + cloudsqladmin

Not sure of the kind of transactions you are seeing and how are you displyaing them but according to the documentation the last step of a maintenance includes:

"The updated database engine is started on the data disk. Using a common data disk ensures that all transactions written to the original instance prior to maintenance are still present on the updated database after maintenance. If any incomplete transactions didn't finish rolling back during database shutdown, the database automatically goes through crash recovery to ensure that the database is restored to a usable state." 

Which might explain those transactions that you see. 

On Thursday, February 17, 2022 at 11:30:38 AM UTC+1 pedroagus...@gmail.com wrote:
Hi,

Does anyone know if the cloudsqladmin user performs some type of task after a scheduled maintenance, cloudsql postgres instance.
Once the maintenance is finished, the cloudsqladmin transactions per second increased considerably. I couldn't find anything in the documentation.

Any hints are much appreciated! 

--
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/1c7e6495-0c3e-405f-b890-af258b9a2453n%40googlegroups.com.

No comments:

Post a Comment