maria-developers team mailing list archive
Mailing list archive
Re: More Secure Kill Command
On Aug 17, Roberto Spadim wrote:
> yeah i liked this idea about query_id too...
> the query_id is currently implemented? or should be implemented? sorry i'm
> asking without reading the source code ...
It is implemented. Currently, KILL works like (kill_one_thread function)
if (tmp->thread_id == id)
to kill by query id, it should be simply
if (tmp->query_id == id)
And some safety checks, of course. Not really a one-line change, but
> about syntax, should it be
> KILL <thread_id> <query_id>
> KILL <thread_id> QUERY <query id>
I don't have a good one. May be
KILL QUERY ID nnn ?
So that the full syntax would be
KILL [ CONNECTION | QUERY [ ID ] ] nnn;