Is this related to caching of results?
I was running a very large query on a VG that timed out ... Memory was pretty high at first:
top - 18:11:09 up 3 days, 2:18, 1 user, load average: 0.82, 0.32, 0.11
Tasks: 138 total, 1 running, 74 sleeping, 0 stopped, 0 zombie
%Cpu(s): 12.4 us, 0.1 sy, 0.0 ni, 87.5 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 65969580 total, 40715056 free, 16869792 used, 8384732 buff/cache
KiB Swap: 0 total, 0 free, 0 used. 48371348 avail Mem
After running and timing out, the memory was reduced significantly:
top - 18:21:20 up 3 days, 2:28, 1 user, load average: 0.22, 0.68, 0.48
Tasks: 139 total, 1 running, 74 sleeping, 0 stopped, 0 zombie
%Cpu(s): 10.4 us, 0.1 sy, 0.0 ni, 89.6 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 65969580 total, 36169432 free, 21404292 used, 8395856 buff/cache
KiB Swap: 0 total, 0 free, 0 used. 43836828 avail Mem
I ran another smaller query and the memory reduced further:
stardog-admin query list
+----------+----------+-------+------------+--------------+---------+--------------+
| Query ID | Database | User | Query Type | Elapsed time | Status | Timeout |
+----------+----------+-------+------------+--------------+---------+--------------+
| 510 | logx | beau | SPARQL | 00:00:03.486 | Running | 00:20:00.000 |
+----------+----------+-------+------------+--------------+---------+--------------+
1 queries running.
ubuntu@bbn-stardog-for-testing:~$ top
top - 18:23:14 up 3 days, 2:30, 1 user, load average: 0.12, 0.53, 0.45
Tasks: 138 total, 1 running, 74 sleeping, 0 stopped, 0 zombie
%Cpu(s): 0.1 us, 0.1 sy, 0.0 ni, 99.8 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 65969580 total, 35691084 free, 21683676 used, 8594820 buff/cache
KiB Swap: 0 total, 0 free, 0 used. 43557464 avail Mem
Is this expected? Eventually, I have experienced OOM issues.
I would like to prevent these.
Andrea