Very high CPU Usage for few hrs every day

[itipltestacnt itipltestacnt]

Hi

Our instance configuration is this

6 core with 18 GB RAM

We dont get much traffic to our site, but for last 1 week we have been noticing that the mysql server CPU usage is every high, something like 500%. After 2-3 hrs it goes back to normal. This usually happens between around 11 AM  to 2 PM. I tried process list but there is nothing abnormal. Not sure where to look for as i am mostly a dev and dont have much db experience 

Any pointers ??? 

[Katayoon (Cloud Platform Support)]

Hi,

Diagnosing issues with your Cloud SQL instance, you may inspect the Cloud SQL instance operation logs or the instance error logs. There is a likelihood that you are running a workload with intensive queries at the mentioned interval. 

If you couldn't find the root cause in the logs, I recommend to raise a PRIVATE report in the Issue Tracker and provide us with your project number, instance id and the timestamp you get these spikes along with your zone to investigate the issue efficiently.