POST worked and it is *connection*/kill/id Thanks a lot and have a great weekend
On Friday, 5 June 2015 16:26:50 UTC+1, l.garulli wrote: > > Hi, > Did you use POST or GET? In order to kill a connection you should issue a > POST HTTP command. > > Best Regards, > > Luca Garulli > CEO at Orient Technologies LTD > the Company behind OrientDB <http://orientdb.com> > > On 5 June 2015 at 16:30, James Wang <[email protected] <javascript:>> > wrote: > >> Sir, >> >> My OrientDB version 2.0.10 and just tried again: >> >> Command not found: http://myserver:2480/connection/kill/60 >> >> 60 - my new connectionId >> >> >> http://myserver:2480/connections/kill/60 >> >> returned >> >> {"connections":[]} >> >> >> but the slow query still runs >> >> >> Have I done it wrongly please? >> >> >> Thanks a lot >> >> >> >> >> On Friday, 5 June 2015 15:20:13 UTC+1, l.garulli wrote: >>> >>> Hi, >>> *connection* is the right one, not "connections". >>> >>> Best Regards, >>> >>> Luca Garulli >>> CEO at Orient Technologies LTD >>> the Company behind OrientDB <http://orientdb.com> >>> >>> On 5 June 2015 at 15:21, James Wang <[email protected]> wrote: >>> >>>> Found how to kill a slow query: >>>> http://orientdb.com/docs/2.0/orientdb.wiki/OrientDB-REST.html >>>> >>>> There is a typo in the above page: connection should be connections >>>> i.e. to kill query id 36, browser >>>> http://yourserver:2480/connections/kill/36 >>>> >>>> Still to find how to timeout automatically >>>> >>>> Thanks >>>> >>>> On Friday, 5 June 2015 12:39:50 UTC+1, James Wang wrote: >>>>> >>>>> Hi All, >>>>> >>>>> How to kill a slow query from console.sh please? >>>>> >>>>> Also, is there a setting which automatically timeout a long slow >>>>> query? >>>>> >>>>> Thanks a lot in advance >>>>> >>>>> >>>>> On Thursday, 4 June 2015 09:06:28 UTC+1, James Wang wrote: >>>>>> >>>>>> Hi All, >>>>>> >>>>>> I am new to OrientDB and like it. >>>>>> >>>>>> I have two classes: users and userFriends >>>>>> users class, with properties like name, email (unique) et al, has 9m >>>>>> fake records and userFriends class >>>>>> (with properties like name, group et al) has 1m fake records; >>>>>> >>>>>> For statistic purpose, I need to find out, for example, those who are >>>>>> not John (whose @RID #12:0 in userFirends class) friends. The query I >>>>>> run: >>>>>> select * from users where email not in (select email from (traverse >>>>>> in() from #12:0)) limit 10; >>>>>> >>>>>> "traverse in() from #12:0" has 20000 edges (i.e. John has 20000 >>>>>> friends - too many - is it not? - just for testing ideas) >>>>>> >>>>>> What have I done wrong please? >>>>>> >>>>>> BTW, if users only has 1m records and John only has only 2000 friend, >>>>>> the query "select * from users where email not in (select email from >>>>>> (traverse in() from #12:0)) limit 10;" only took 0.2 seconds >>>>>> >>>>>> Please help >>>>>> >>>>>> Thanks a lot in advance >>>>>> James >>>>>> >>>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "OrientDB" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
