Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.12
-
None
-
3.2.0-4-amd64 #1 SMP Debian 3.2.35-2 x86_64 GNU/Linux
Description
1) Create remote connection to DB: CREATE TABLE ... ENGINE=CONNECT TABLE_TYPE=MYSQL SRCDEF='slow query'
2) SHOW PROCESSLIST command shows the state of the query "creating table", command = "Query".
3) Try to kill the query by KILL ID command. SHOW PROCESSLIST command shows "Killed" but the query freezes untill it will finish on the remote server (it can take a very long time).
4) The desired behaviour is to kill the query remotely or/and speed up the local KILL command.