We have a Django Application (hosted on Compute Engine), that uses Cloud SQL. We've set up really frequent monitoring of it in the Load Balancers health checks. We do however about once per day get a bunch of the following errors: django.db.utils:OperationalError: (2013, 'Lost connection to MySQL server at \'reading initial communication packet\', system error: 0 "Internal error/check (Not system error)"').
Typically the MySQL/Cloud SQL interaction of the health checks takes less than 20ms, however a few times a day the it can suddenly take 500-1200 ms.
The database is really lightly loaded (health checks count for > 95% of the requests to the system) and we've not seen any similar issues during heavy load testing. There just seems to be something randomly causing Cloud SQL to perform really slowly for a request or two or drop the connections and then continue to work normally.
What could be the reason to both loosing the connection and to the random, but extreme slowness? Any ideas on how to possibly fix both issues?
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/21b7c9b2-eee6-459c-9b69-ba7d2fcbd740%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment