yeah i liked this idea about query_id too... thread_id + query_id is a nice solution (at least i think it will work)
i was considering query start time too, but since kill isn't a command with very high frequency (kills/second), the query_id could solve the problem nicely
the only problem i can see is: if thread id is low (example connection id = 50), and we have a server restart and at the same thread id (50), runs the same number of queries...
well the probability is very very small... at least i think it is, and if we execute the KILL, we will get a connection lost from server... and we should execute the show processlist again...
if we don't want the show processlist again, just add the query start time (YYYY-MM-DD HH:MM:SS), but for the first implementation query id is nice...
the query_id is currently implemented? or should be implemented? sorry i'm asking without reading the source code ...
about syntax, should it be
KILL <thread_id> <query_id>
or
KILL <thread_id> QUERY <query id>
?
thanks guys :)