[google-cloud-sql-discuss] Re: The write SQL is always running

You can check your instance's flags settings, as some of them can increase the writes, for example [1].

Also, in case you haven't already, enabling the data access audit logs [2] can help you see who is doing these writes to the database so you can take the necessary steps to stop the writes.

[1]: https://cloud.google.com/sql/docs/mysql/flags#:~:text=sync_binlog

[2]: https://cloud.google.com/logging/docs/audit/configure-data-access#enabling-one-service

On Thursday, June 3, 2021 at 9:27:58 AM UTC+2 Ted Gong wrote:

This page said internally cloudsql reverses up to 6 connections. Maybe they are doing something with that? 

1Cloud SQL for PostgreSQL reserves up to six of these connections for internal operations.
https://cloud.google.com/sql/docs/quotas#:~:text=Cloud%20Run%20services%20are%20limited,connections%20per%20deployment%20can%20grow.

On Wednesday, June 2, 2021 at 3:04:20 AM UTC-7 Nobuhito wrote:

Hello, 

When I checked the details of Cloud SQL, the SQL for writing was always executed, and the storage was increasing steadily.

The SQL for writing seems to be running all the time, even though I haven't sent any SQL queries.

What is the SQL for this write?

How can I stop it?

I also contacted customer support in Japan, but they couldn't solve it.

Best regards,

Nobuhito

--
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/963d7bb0-2128-4f58-9031-9791ff64d561n%40googlegroups.com.