Stop a running Query
| User, date | Message |
|---|---|
|
Written by Koch
5 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
5 years ago 3951 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. Dave
5 years ago 95 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
5 years ago 3951 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
2 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. |