did you try what I told you? the *show processlist;* command will show you the query id. On Fri, Aug 16, 2013 at 5:54 PM, Roberto Spadim <roberto@spadim.com.br>wrote:
hum same problem the ID is the connection id, not the query id... example
if i execute: (1 = one connection, 2 = other connection) 1)mysql_connect... (create a connection id) 2)mysql_connect... (create a connection id) 1)show processlist (i will see 1 and 2 connection id) 1) select * from big table 2)show processlist -> let's tell it return connection: 1)id = 10, 2)id = 11 1) select * from another big table 1) select * from another big table 1) select * from another big table 1) select * from another big table 1) select * from another big table 1) select * from another big table 2)show processlist -> it return connection: 1)id = 10, 2)id = 11 see? there's no change at id... maybe expose the query id solve this problem.. (in this case it should return ~8 to (1), and ~2 to (2)) i'm using mariadb 10.0.3 here
any idea?
-- Gabriel Sosa Sometimes the questions are complicated and the answers are simple. -- Dr. Seuss