How can I stop a running MySQL query?

mysql kill processlist
David B picture David B · Sep 24, 2010 · Viewed 377.1k times · Source

I connect to mysql from my Linux shell. Every now and then I run a SELECT query that is too big. It prints and prints and I already know this is not what I meant. I would like to stop the query.

Hitting Ctrl+C (a couple of times) kills mysql completely and takes me back to shell, so I have to reconnect.

Is it possible to stop a query without killing mysql itself?

Answer

baklarz2048 picture baklarz2048 · Sep 24, 2010 
mysql>show processlist;

mysql> kill "number from first col";

Related questions

Terminating idle mysql connections

I see a lot of connections are open and remain idle for a long time, say 5 minutes. Is there any solution to terminate / close it from server without restarting the mysql service? I am maintaining a legacy PHP system and …

Read More
How do I kill a transaction in MySql as root?

I’m using MySql 5.5.37. As root, I’m trying to kill a transaction that’s locking some tables. I run SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX\G and get the output … *************************** 6. row *************************** trx_id: 143E6CDE trx_state: RUNNING trx_…

Read More
What happens if you kill a long-running alter query?

What happens if you kill a long-running alter query? Will the alter query simply revert? How long could that take (as a proportion of the time it has already been running)? What if that query is being replicated onto another …

Read More