[MonetDB-users] Memory Usage
Hi ! I'm runnig MonetDB under Linux Ububtu with 4Gb of RAM. I need to benchmark it running 1Gb, 2Gb, 3Gb and 4Gb. Todo so I need to limit the memory usage. How can I configure MonetDB to limit it's memory usage? and doing so am I able to run complex queries (with short memory) ? Regards Rui Anastácio
Rui Anastácio wrote:
Hi !
I'm runnig MonetDB under Linux Ububtu with 4Gb of RAM. I need to benchmark it running 1Gb, 2Gb, 3Gb and 4Gb. Todo so I need to limit the memory usage. MonetDB fully relies on the memory limits imposed by the OS, e.g. ulimit and/or RAM and/or swap space. How can I configure MonetDB to limit it's memory usage? and doing so am I able to run complex queries (with short memory) ? depends on many factors.
Regards Rui Anastácio
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On 23-12-2009 12:31:08 +0000, Rui Anastácio wrote:
Hi !
I'm runnig MonetDB under Linux Ububtu with 4Gb of RAM. I need to benchmark it running 1Gb, 2Gb, 3Gb and 4Gb. Todo so I need to limit the memory usage. How can I configure MonetDB to limit it's memory usage? and doing so am I able to run complex queries (with short memory) ?
You can use ulimit to limit the available memory to the process. I successfully experimented with this, and made a little fix to MonetDB, but that has only been applied to the development sources. There were plans at some point to port that fix back to the current release branch.
Could you elaborate a little more on what the fix does? Fabian Groffen wrote:
On 23-12-2009 12:31:08 +0000, Rui Anastácio wrote:
Hi !
I'm runnig MonetDB under Linux Ububtu with 4Gb of RAM. I need to benchmark it running 1Gb, 2Gb, 3Gb and 4Gb. Todo so I need to limit the memory usage. How can I configure MonetDB to limit it's memory usage? and doing so am I able to run complex queries (with short memory) ?
You can use ulimit to limit the available memory to the process. I successfully experimented with this, and made a little fix to MonetDB, but that has only been applied to the development sources. There were plans at some point to port that fix back to the current release branch.
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://old.nabble.com/Memory-Usage-tp26901708p26903322.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 23-12-2009 07:07:32 -0800, Alex Bo. wrote:
Could you elaborate a little more on what the fix does?
It makes the MonetDB kernel aware of the ulimit memory limitation, such that it can base its predictions upon the actual memory limit, instead of just the amount of physically installed memory. Patch: http://monetdb.cvs.sourceforge.net/viewvc/monetdb/MonetDB/src/gdk/gdk_system.mx?r1=1.120&r2=1.122&diff_format=u
participants (4)
-
Alex Bo. -
Fabian Groffen -
Martin Kersten -
Rui Anastácio