On 08-08-2012 13:37:14 +0200, Christian Braun wrote:
Hello,
i would like to limit the memory usage of MonetDB to half of the physical available memory. This is on Debian 6.0 64-bit with 48GB memory. I added to /etc/default/monetdb: ulimit -v 25165824
On startup MonetDB still reports: 2012-08-08 13:21:30 MSG db[15678]: # Found 47.262 GiB available main-memory.
cat /proc/15687/limits shows the limit: Limit Soft Limit Hard Limit Units Max address space 25769803776 25769803776 bytes
Unfortunately on the first query i run the database gets killed: 2012-08-08 13:21:54 MSG merovingian[15663]: database 'db' (15678) was killed by signal SIGSEGV
Is there a way to limit the memory usage of MonetDB on Linux?
No. MonetDB will take what is available. Since Jul2012 the code tries to release memory more actively when the server detects some of its memory gets swapped out.