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?