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