← Back to team overview

maria-discuss team mailing list archive

Re: More secure Kill command

 

hi!
well, what i'm doing...

SELECT * FROM `information_schema`.`PROCESSLIST`;

this give me a table with this fields:

`ID` BIGINT(4) NOT NULL DEFAULT '0',`USER` VARCHAR(128) NOT NULL
DEFAULT '',`HOST` VARCHAR(64) NOT NULL DEFAULT '',`DB` VARCHAR(64)
NULL DEFAULT NULL,`COMMAND` VARCHAR(16) NOT NULL DEFAULT '',`TIME`
INT(7) NOT NULL DEFAULT '0',`STATE` VARCHAR(64) NULL DEFAULT
NULL,`INFO` LONGTEXT NULL,`TIME_MS` DECIMAL(22,3) NOT NULL DEFAULT
'0.000',`STAGE` TINYINT(2) NOT NULL DEFAULT '0',`MAX_STAGE` TINYINT(2)
NOT NULL DEFAULT '0',`PROGRESS` DECIMAL(7,3) NOT NULL DEFAULT
'0.000',`MEMORY_USED` INT(7) NOT NULL DEFAULT '0',`EXAMINED_ROWS`
INT(7) NOT NULL DEFAULT '0'

I'm using the ID to kill...


KILL <id here>

the problem is, query is executed (no problem) but the ID don't
change... in other words the ID here is the connection id, not the
query id...

there's a place to get the query id? and just kill it? i didn't read
this at mysql docs, i will check again

Follow ups

References