Hello, I'm trying to use ulimit to limit memory but it doesn't work. My steps are: 1. Open a shell 2. write ulimit -m 4194304 3. and start mserver5 When I'm in a client I execute a query and with comand top I can see that is using more than 4194304 kbytes. After several trials I did the same but limiting the cpu time with: ulimit -t 3 and it works fine, after 3 seconds the server was killed. I don't understand what is happening, the only thing I can supouse is that ulimit can't be used with monet. I hope a solution. Thank you. Mike El lun, 14-06-2010 a las 14:33 +0200, Fabian Groffen escribió:
Hi Miguel,
On 11-06-2010 14:02:14 +0200, Miguel Ángel Águila Lorente wrote:
I'm trying to limit the memory that monetdb can use during its executions. I'm using mal language and I've found this operation in order to do it.
command mem_maxsize(v:lng) :void address set_mem_maxsize comment "Set the maximum usable amount of physical swapspace in KB.";
When I use this operation the connection is terminated. I let here some examples: (I'm working with a machine with 32 GB)
This operation is most probably not doing what you want. The crash you reported is not dependant on the value you supply, it cannot be avoided. In short, it's flawed, so don't use it. If you want to limit monetdb's memory usage, you better go with ulimit.
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users