Thanks Carl for those graphs.

Just from the latency graph I would say that there are some very slow 
requests (because 95th percentile is 0.5 second but the 99th percentile is 
over 7 seconds) and that the change seems to have occurred on the 3rd of 
October.

Now, because we're suspecting the CloudSQL server to be the bottleneck, can 
you look at it in the Cloud Console? 
(https://console.cloud.google.com/sql/instances). Probably the most useful 
graphs would be the "CPU utilization", "Read/write operations" and "MySQL 
queries" for the last 30 days.

I also found it useful to look at the running queries using something like 
mytop (https://www.tecmint.com/mysql-performance-monitoring/) or just doing 
"SHOW FULL PROCESSLIST" repeatedly.

All the best,
Attila

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/6cf24cbe-e425-407e-b469-e09846e76971%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to