Saturday, December 12, 2015

[google-cloud-sql-discuss] Our application has become slow since Dec 8. Please help.


Our Google app engine application was developed in java and hibernate framework is connected with cloudSQL.

No changes has been done to code in the past three months.

Typically the page loading time is very good and pages load in 3 seconds.

Query execution takes 2 or less seconds to execute.

From December 8th, our application has become very slow and it takes upto 15 seconds to load the pages.

I have visited status.cloud.google.com and looks like all services seem to be normal in my cloud console.

From the stats I notice that Google App Engine Service Outage occurred on Dec 8 and Dec 9.

Refer screens attached.


Also from the traces, the rdbms.openConnection and rdbms.Exec takes long time to execute.

 

I have done the following to improve the performance,


1. Checked the Memcache service.

2. Stopped the queue process.

3. Modified the performance settings.

4. I checked the Google API services enabled for our application and disabled the unwanted API.

5. Updated the appengine SDK to the latest version and deployed the application in new version.

 

Can anyone suggest the reason behind this sudden slow responses and how to get our application back to its previous performance. I would really appreciate your help.


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/677d7910-d1f1-475b-8d52-87b25087b6a6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment