The write SQL is always running

[Nobuhito]

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

[Ted Gong]

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.

[goya]

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