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 <[email protected]>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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
