the ID is the connection id, not the query 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?