Hi Daniel, Thought I sent this already but seems to have gotten stuck in outbox ...
Memory resource consumption improved/reduced by setting ThreadCleanupInterval
and ResourcesCleanupInterval in the INI file as detailed in the docs at:
http://docs.openlinksw.com/virtuoso/dbadm/
>>>
Example 6.2. Using the ThreadCleanupInterval and ResourcesCleanupInterval ini
file option
[Parameters]
....
ThreadCleanupInterval = 1
ResourcesCleanupInterval = 1
...
Set both to 1 in order to clean up unused threads/resources and reduce memory
consumption of the Virtuoso server, which can otherwise be construed as memory
leaks.
<<<
Note on a Linux system, "SwapGuard = 1" can also be set in the "[Parameters]"
section of the INI file with suitable swap space allocated for the OS, then if
the OS starts swapping when system memory is getting low Virtuoso will start
killing active statements to free memory, preventing the complete depletion of
system memory by Virtuoso and hence it being killed by the kernel, due to
possible out of memory errors.
I assume you already have swappiness set as detailed in the Virtuoso RDF
Performance Tuning Guide at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning#Linux-only%20--%20"swappiness";
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 21 Jul 2016, at 15:45, Davis, Daniel (NIH/NLM) [C] <daniel.da...@nih.gov>
> wrote:
>
> Virtuoso-opensource in my environment is using 79% - 83% of memory after
> several weeks of nightly TTLP and daily queries.
> When I restart it, it is using 26% of memory (on a 16GB machine).
>
> I cannot restart it in my nightly data processing jobs, because that requires
> root, and my jobs do not run as root.
>
> Is there a way I can synchronously cause it to release unused pages on
> demand, maybe after connecting via isql as admin?
>
> Thanks,
>
> Dan Davis, Systems/Applications Architect (Contractor),
> Office of Computer and Communications Systems,
> National Library of Medicine, NIH
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
> patterns at an interface-level. Reveals which users, apps, and protocols are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity planning
> reports.http://sdm.link/zohodev2dev_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
