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