CPU high after maintenance

[Mark Nordine]

Usually, we have cpu % humming along at 8%. Google did some maintenance on our MySQL 5.7 db instance today, and immediately after that, we're seeing high cpu usage. We did nothing on our end. Anybody else seeing this? Any tips on how to troubleshoot?

[Mark Nordine]

I noticed our memory usage shot down at the time of maintenance (10 am). It doesn't seem to have been restarted though. 

[abhishek singh]

Which region are you located, i don't see any maintenance, again it depends on GCP scheduling.   I don't see any change in our environment, but there was no update from GCP as well. 

[Mark Nordine]

us-east-1-d. Database was restarted, but that was never an issue in the past. 

[abhishek singh]

we are also in east but in east4 region, nothing in our environment

[Mark Nordine]

It was planned maintenance for us. Haven't experienced this at all in the past.

[abhishek singh]

did you peaked into logs? last year, it happened to us as well, saw small spike in CPU and lot of errors related to timeout

[Mark Nordine]

I see a lot of queries "Creating sort index" over and over again, but I have no idea why. It's like it won't use the RAM.

[Mark Nordine]

I had to rewrite that particular query, :(

[Mark Nordine]

Actually I had to modify my application logic to use the old query as a fallback, and a new query as a fast path. We had no issues with our query before maintenance.

[jstsetinin]

Hello,

Does the issue still persist? If yes it is better to open a ticket with GCP support.