← Back to team overview

maria-discuss team mailing list archive

Re: More secure Kill command

 

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?



Follow ups

References