humm... i will think more about this... maybe i'm too crazy (and unlucky) to understand that the order isn't important... i will check again what i write in last email... please check too and tell me if the order of increase isn't a problem
2013/8/17 Roberto Spadim <robe...@spadim.com.br> > sergei... one more point... i was looking the mk-kill > http://linux.die.net/man/1/mk-kill > > there's some cases where we want to kill a thread that's no running any > query and we need to kill it only when it is not running any query, in > other words i can't use kill thread id, i must use kill query id.... > the point here is "how query id is increased?" for example.. > > > (query id = 0 thread id = 10) <- kill query id =0 > > [query received] > query id ++ (query id = 1 thread id = 10) > SELECT * FROM TABLE <- kill query id =1 > [query done] > (query id = 1 thread id = 10) <- kill query id =1 > > > [query received] > query id ++ (query id = 2 thread id = 10) > SELECT * FROM TABLE <- kill query id =2 > [query done] > (query id = 2 thread id = 10) <- kill query id =2 > > > (query id = 2 thread id = 10) <- kill query id =2 > > > if i send a KILL QUERY ID = 2, i will only kill the last SELECT, or if the > select is done, i will kill the thread with the last executed query id = 2 > > see the problem? the query id can't be reseted, and it MUST be increased > only when we START a new query, not at the end of query, example: > > > > > (query id = 0 thread id = 10) <- kill query id =0 > > [query received] (query id = 0 thread id = 10) > *SELECT * FROM TABLE <- kill query id =0* > query id ++ (query id = 1 thread id = 10) > [query done] > *(query id = 1 thread id = 10) <- **kill query id =1 !!!!* > > > [query received] (query id = 1 thread id = 10) > *SELECT * FROM TABLE <- kill query id =1 !!!!* > query id ++ (query id = 2 thread id = 10) > [query done] > (query id = 2 thread id = 10) <- kill query id =2 > > > --- > Is the QUERY ID increased ONLY WHEN A QUERY START, AND the QUERY ID isn't > reseted AFTER query execution? > > If yes, this is ok, we can kill a thread that is not running a query > without problems using query id > in this case no problems... > > bye > -- Roberto Spadim SPAEmpresarial
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
