distal-attribute
distal-attribute
distal-attribute
distal-attribute

Stop a running Query

User, date Message
Written by Koch
6 years ago
Category: General
1 posts since Wed, 16 Jul 08
Hello All,

I 'm new with HeidiSql, I post here cause i've not found the answer i'm looking for.

Is there a way to stop a running query,without kill the HeidiSql Process in Windows ?
Written by ansgar
6 years ago
5012 posts since Fri, 07 Apr 06
Yes:
1. Open a second HeidiSQL session to the same server
2. Go to Host -> Processlist
3. Find the evil process and kill it using [Del] or context menu
The running HeidiSQL instance will get some error "Cannot retrieve resultset" but that can safely be ignored.
Written by Dr. DaveMoney, Euro
6 years ago
105 posts since Sun, 27 Jan 08
Not really sure what the harm would be in killing the HeidiSQL process to end the stalemate, but thanks Anse for a workable solution.
Written by ansgar
6 years ago
5012 posts since Fri, 07 Apr 06
Killing heidisql.exe can mean you loose a written SQL query in the query editor. Apart from that, no big impact.
Written by rojaro
4 years ago
1 posts since Fri, 17 Dec 10
It would be really nice if we had a behavior like in the native mysql commandline client where i can press CTRL+C to abort the current query and have heidisql automatically send "KILL QUERY <thread_id>".
 

Please login to leave a reply, or register at first.