1

My app is inactive, waiting for a http request.
Nevertheless, the MySQL database received a permanent 15 requests(writes) per second, day and night.
Then, I have stopped replication, and binary logging.
Now, the graph shows about 6 requests(writes) per second, with a peak to 10 req/sec every 5 mn.
Can you help me to stop that costly load?
graph showing permanent load

Maxim
  • 4,075
  • 1
  • 14
  • 23
denis.a
  • 11
  • 2

1 Answers1

1

Over at the documentation for Cloud SQL metrics, you can find the following:

The Number of Writes metric is the number of write operations to disk. Write activity is generated even if your application is not active, because Cloud SQL instances write to a system table approximately every second (except for replicas).

This is most likely what you are seeing in the metrics of your instance. You can read more over at https://cloud.google.com/sql/docs/mysql/instance-info#available_metrics

rsalinas
  • 1,507
  • 8
  • 9
  • I understand, thanks. My previous sql database on Google App Engine had not such periodic writes: cheaper. – denis.a Aug 17 '18 at 19:31