Hi Attila I do not think that the Cloud SQL server is the bottleneck as Compute Engine connects to Cloud SQL perfectly fine, it is just that something might have changed on AppEngine environment around 3-8th October that has caused a slow down.
Here are the graphs for Cloud SQL over the past 30 days <https://lh3.googleusercontent.com/-O1ud0a-GFjQ/W8nu_Y_UO2I/AAAAAAABazM/c5147hjtv30317oBIzkuYWhDtJ7SdTStQCL4CGAYYCw/s1600/SQL_Usage.PNG> <https://lh3.googleusercontent.com/-bHjExkxCm9A/W8nu_aqa8aI/AAAAAAABazM/cUtjwAqKxOkmz1w31aVcahzfESoNFo7MQCL4CGAYYCw/s1600/SQL_ReadWrite.PNG> <https://lh3.googleusercontent.com/-cze4211Vgis/W8nu_VZ6c2I/AAAAAAABazM/g7PX2dpCT3gImnpgT8yFHpUoCbS4ZyIIACL4CGAYYCw/s1600/SQL_Queries.PNG> The issue has been escalated to the Cloud SQL team for them to look into this. On Friday, October 19, 2018 at 4:22:01 AM UTC+1, Attila-Mihaly Balazs wrote: > > 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/18e2a5e8-7d0d-46cd-b85e-5f3ce5f36475%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
