Stop a running Query

Koch posted 9 years ago in General
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 ?
ansgar posted 9 years ago
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.
Dr. Dave posted 9 years ago
Not really sure what the harm would be in killing the HeidiSQL process to end the stalemate, but thanks Anse for a workable solution.
ansgar posted 9 years ago
Killing heidisql.exe can mean you loose a written SQL query in the query editor. Apart from that, no big impact.
rojaro posted 7 years ago
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.