[google-cloud-sql-discuss] Re: Cloud SQL First Generation hang this morning?

Hello Allen,

Do you have query log enabled on your CloudSQL instance ? If yes, you can query the log table which might provide you with more insight. You can refer to this link for more information on slow query log. If its not enabled, you can visit the link for steps to enable it to debug the issue in future.

I hope that helps.

Faizan

On Tuesday, January 26, 2016 at 11:38:06 AM UTC-5, Allen Firstenberg wrote:

Our automated processes on GCE went to execute a DROP TABLE command on one of our Cloud SQL tables this morning around 3am ET. This is part of a regular set of commands that are issued this time every week. The Cloud SQL instance is a First Generation D4.

Most weeks it takes about 3 seconds.

This week it took over 2.5 hours - until 5:41:35 am ET.

The CPU usage graph on our cloud console also indicates no CPU activity on the Cloud SQL instance until this time as well.

The GCE status page reports no issues during this time.

Is there any way we can figure out what happened and how to prevent it from happening again?

Thanks!

--
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/cefa4826-9ff2-4940-a0b3-6b116cf99499%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.