you can get the query id running: show processlist; show full processlist; you will see the id as the first left column. Again, try installing innotop or mtop, they will make your like a lot easier... Regards On Fri, Aug 16, 2013 at 5:42 PM, Roberto Spadim <roberto@spadim.com.br>wrote:
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
-- Gabriel Sosa Sometimes the questions are complicated and the answers are simple. -- Dr. Seuss