Stop a running Query

[expired user #3572]'s profile image [expired user #3572] posted 16 years ago in General Permalink
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's profile image ansgar posted 16 years ago Permalink
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.
[expired user #3333]'s profile image [expired user #3333] posted 16 years ago Permalink
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's profile image ansgar posted 16 years ago Permalink
Killing heidisql.exe can mean you loose a written SQL query in the query editor. Apart from that, no big impact.
[expired user #5393]'s profile image [expired user #5393] posted 13 years ago Permalink
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.