Hi Pascal,
The following section in the documentation details the need to increase the
MaxQueryMem ( or c_max_large_vec with __dbf_set) if the "mp_mmap_clocks over
10% .." messages appear in the log which is an indication of more memory being
needed to the query workload:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#tunparamsmworkload
<http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#tunparamsmworkload>
You indicate The server has 4GB RAM, how many buffers (NumberOfBuffers) are
set in the INI file and also, if you run the "status('');" command how many are
actually in use when running typical workload ? As it MaxQueryMem is increased
then there should be available system memory, so check with "top" or other
command how much is available on the system and the number of Buffers Virtuoso
is using and if possible reduce the number allocated in the INI file to free
more memory.
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 3 Feb 2015, at 04:55, Pascal Heus <pascal.h...@mtna.us> wrote:
>
> Our VOS7 went down today on our development system. About 12 hours
> prior to the crash following messages started to show in the log:
> Monitor: The mp_mmap_clocks over 10% of real time
> This comes from the monitor.c file and seem memory related. Could you
> clarify what this means?
> We suspect our server was running out of virtual memory or swapping too
> much. We're testing with a 5-6Gb database, using Version
> 07.10.3211-threads for Win64 as of Jul 10 2014 running on NT2008
> w/1-core 4Gb RAM (AWS t1.medium instance). Last restart was Jan 8th (25
> days ago)...
> best
> *P
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
