Google Cloud SQL migration to second generation caused spike in Read/Write operations

0
votes

I had to migrate from Google Cloud first generation SQL to second generation SQL (MySQL 5.6) instance.

When I check the performance charts in the SQL dashboard in Google cloud, what strikes me is the huge spike in "read/write operations", since the moment of migration.

What is more interesting is "MySQL queries" chart, remains the same, same number of queries on average, no difference since the migration.

Can anyone tell me what can make read/write operations significantly higher while the number of queries remain the same ?

I attach screenshots of "MySQL queries" vs "Read/write operations".

enter image description here

enter image description here

1
mysqlsqlgoogle-app-enginegoogle-cloud-platformgoogle-cloud-sql
is high availability enabled on your instance? - Jan Hernandez
@JorgeHDZ Yes it is. - buckyBadger
I think that's caused by HA tasks, you could try to disable the HA instance and check if reads and writes decrease - Jan Hernandez
@JorgeHDZ This didn't change anything. - buckyBadger

1 Answers

0
votes

I think that this issue is related with the product, maybe is good idea file a case with customer support to check the issue on a deeper way.