Well, normally TigerGraph runs on a dedicated platform/hardware and thus it is given all resources, as it is a database server, not just any application. It is actually a desired behaviour to use call CPUs as intensively as possible (for as short time as possible, i.e. do the work as quickly as possible). Production instances of TigerGraph should be run on dedicated instance(s).
If you need to restrict CPU usage, then probably you should run TigerGraph in a virtual machine or a container where you can specify the resource limits.
I will check it there is a way (some config parameter) to limit CPU/thread usage, but I would not be surprised if there was not (as it would contradict our intention to be the fastest graph database/platform).
Ok, thanks.
We are still testing if tigergraph is appropriate for our intended use, that’s why we have installed it in this server which is for general purpose. But of course, in production we would run it on a dedicated instance.
Thanks! I tried cpulimit and it worked.
However, I got another issue, because it took very long and it timed out (although I allowed it to use up to 100 cpus which I think was much more than enough for the task).
I need to use a vpn to connect to the server where tigergraph is stored and the vpn sometimes falls or kicks me out. So I prefer running things with nohup so that they will keep running even if my session stops.
I have tried other small queries (like getting the neighbors or 2 step neighbors of a node) with GraphStudio, which finished on time.
But this one has to search through all the nodes of a certain type and return only the ones between two dates. I supposed it would take long, but not this long
Ok, I tried again with different queries after setting the timeouts to a higher threshold and I still get the same answer and didn’t fnd anything suspicious in the log files, this is what I get adding -v option:
I think that proxy setting limit is 2 hours.
-v option was helpful since it provided information that it was not the client dropping connection.
I asked my engineering to provide me options howto adjust the proxy timeout, still waiting on answers.