Hello, Thank you for your post. I understand that you have a Cloud SQL instance and Cloud Storage bucket in the us-central region and the access to both of this servers from your local machine is slow.
This could be for many reasons external to the Cloud Platform scope such as: + Temporary bad ISP bandwidth. + Another application(s) in your local machine are using the network bandwidth and it taking the larger part of it. + Another application(s) is using to much CPU power which is slowing the connection processes to your GCP resources. + other local network issues. There was no known incident related to this as it can be seen in [1] In order to help you further I would suggest that you consider all the other possibilities. And then, check with the gsutil tool to check the speeds with the a standard tool. [1] https://status.cloud.google.com/ On Friday, July 10, 2020 at 6:32:48 PM UTC+2, Leonard Cremer wrote: > > Problem you have encountered: > When I download a 83kb file from cloud storage it takes between 5 and 12 > seconds where from my local machine it takes between 2 and 5 seconds. > My cloudSQL inserts are also much slower than when tested from another > server to CloudSQL so it seems to be related. > > What you expected to happen: > I expect this to be very fast as it is both on the us-central servers > > Steps to reproduce: > let filename = `${routeKey}.json.gz`; > logger.info > <https://www.google.com/url?q=http://logger.info&sa=D&usg=AFQjCNGZLuTewKKCnjSHOj9PNrqzV_CnFw>(loggerKey, > > `filename:${filename}`); > const file = storageBucket.file(filename); > logger.info > <https://www.google.com/url?q=http://logger.info&sa=D&usg=AFQjCNGZLuTewKKCnjSHOj9PNrqzV_CnFw>(loggerKey, > > `have file:${filename}`); > const [contents] = await file.download() > logger.info > <https://www.google.com/url?q=http://logger.info&sa=D&usg=AFQjCNGZLuTewKKCnjSHOj9PNrqzV_CnFw>(loggerKey, > > `downloaded:${filename}`); > > Other information (workarounds you have tried, documentation consulted, > etc): > Here is my stackdriver logs linked to the code above. The download step > takes 12 seconds in this instance. > I 2020-07-10T08:18:15.188999891Z > downloaded:159414332187374700443664:ATL:BRU:economy.json.gz > I 2020-07-10T08:18:03.111999988Z have > file:159414332187374700443664:ATL:BRU:economy.json.gz > I 2020-07-10T08:18:03.111000061Z > filename:159414332187374700443664:ATL:BRU:economy.json.gz > I 2020-07-10T08:18:03.111000061Z Starting processSkyJSONFile > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/cacf578f-9861-48fa-b09a-d72a2579bf6eo%40googlegroups.com.
