maria-discuss team mailing list archive

[Gabriel Sosa <sosagabriel@xxxxxxxxx>]

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@xxxxxxxxxxxxx>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