maria-discuss team mailing list archive

[Gabriel Sosa <sosagabriel@xxxxxxxxx>]

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@xxxxxxxxxxxxx>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