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