[google-cloud-sql-discuss] Re: Kill thread on MySQL instance

Since you don't get SUPER with Cloud SQL, the only way that you can kill a query is to login as the user who owns it and kill it.

We keep an (encrypted) plaintext copy of all of our user and application passwords so that we can kill a runaway query if we ever need to.

On Thursday, February 1, 2018 at 2:43:40 PM UTC-5, Shua Talansky wrote:

Whenever I try to do this I get "10952 - You are not owner of thread X" Is there a way to get around this?  

On Monday, January 8, 2018 at 11:34:16 PM UTC-5, Taher (Cloud Platform Support) wrote:

Hello Jacob, 

You can try the below command which might help you resolve the issue.

mysql> show processlist;
mysql> kill "number from first col";

On Monday, January 8, 2018 at 8:56:05 PM UTC-5, Jacob See wrote:

I have some developers working on a Cloud SQL MySQL instance - and one of them ran a query which seems to have gotten stuck. Do I have a way to kill that without rebooting the instance?

--
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/adf19cb0-4a05-4db9-aaa7-770c611de73f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.