December 2007 - users-list

[MonetDB-users] Proofreading your professional documents
by Richard Hounslow 24 Feb '24

24 Feb '24

Dear Professor/Lecturer Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines. Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards. If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance. Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com. We look forward to hearing from you! Yours faithfully Proof-Reading-Service.com

2 2

[MonetDB-users] (no subject)
by Matt Magoffin 11 Aug '08

11 Aug '08

Hello, I am interested in evaluating MonetDB/XQuery. I have some XML collections for a project I work on that are of 1-2 million individual XML documents for which I use XQuery to access for OLAP style reporting operations. This is a Java-based project, and while working on this project I developed a thin XQuery-centric API so that I could evaluate/use many different XQuery implementations, which my company released as an open source project called Xaj (http://sourceforge.net/projects/xaj). Currently I am using a Berkeley DB XML implementation, but am interested in exploring other options. I'd like to implement a MonetDB version of this API now, but I am having some difficulty finding out how to effectively access MonetDB through Java. So far I was able to use the MonetDB JDBC driver to construct XQuery statements and get XML results, and also I was able to construct MonetDB pf:add-doc() statements to add documents, but I am wondering if this is the best approach (and if so, how to add documents to a remote MonetDB server using the pf:add-doc() mechanism). The API I am trying to implement you can view here, to give you an idea what I'm trying to do: http://xaj.svn.sourceforge.net/viewvc/xaj/xaj/src/net/sf/xaj/XmlDb.java?rev… It was somewhat modeled after the defunct XML:DB API, but focused just on add/store/XQuery operations. Any help/advise would be greatly appreciated! -- m@

2 3

[MonetDB-users] db log shrink
by Colin Foss 17 Apr '08

17 Apr '08

Is there any method, besides restarting the database, of shrinking the sql log file? When I am performing a large set of large inserts (via COPY INTO) the log file gets very large. I wish there was a way to cycle the log file. Also during these large batches of inserts the database server becomes less and less responsive until I am forced to restart the server. Upon restart and the normal recovery monet returns to a very responsive state.

3 2

[MonetDB-users] JDBC insert performance
by chinarinde 11 Mar '08

11 Mar '08

Hi all, I am new to monetDB and ran into the following problem (I'll try to be as verbose as I can, perhaps it helps helping me): I've installed MonetDB server 5.0.0, clients and commons 1.18.2 and sql 2.18.2 on Ubuntu Feisty. Then I've taken the JDBC example which is available online and modified it to be able to insert data into a test database. More specifically I'm using prepared statements and executeBatch() together with the monetdb-1.6 JDBC driver. Which is quite successful until about 5 million records are inserted - afterwards the speed of the inserts drops dramatically. I've experimented with different batch sizes (10000 records seems to work ok), and I've tried to understand the chapter about memory tuning for MonetDB (not sure yet about how to use mem_cursize() though). In any case at first inserting 2 million records only takes about 5 minutes (measured with Javas System.timemillis), later on this time increases and the server gets rather unresponsive. I found only two posts concerning the speed of JDBC inserts (from January 2007 I think) and I would be interested if a solution or explanation has been found off-list. Thank you -- View this message in context: http://www.nabble.com/JDBC-insert-performance-tf4589411.html#a13100422 Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

Re: [MonetDB-users] Cannot start mserver5
by Rahul Chopra 28 Dec '07

28 Dec '07

Just letting you know I compiled on CentOS 5.1, and it appears to be working now. Thanks for the help. > ----- Original Message ----- > From: "Martin Kersten" <Martin.Kersten(a)cwi.nl> > To: "Communication channel for MonetDB users" <monetdb-users(a)lists.sourceforge.net> > Subject: Re: [MonetDB-users] Cannot start mserver5 > Date: Fri, 28 Dec 2007 17:59:18 +0100 > > > > Yes, it seems you are right. Download the SuperSourceBall and compile > from that. > The website indicates that the latest stable version works on Centoo. > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql5/.mTests103/index… > > Rahul Chopra wrote: > > Hi Martin, > > > > I am now running as a non-root user. > > > > Here is the output from the stack trace: > > > > Program received signal SIGSEGV, Segmentation fault. > > [Switching to Thread 46912496255632 (LWP 23889)] > > 0x0000000000000000 in ?? () > > > > (gdb) bt > > #0 0x0000000000000000 in ?? () > > #1 0x0000003a1e026d9e in _rl_init_terminal_io () > > from /usr/lib64/libreadline.so.5 > > #2 0x0000003a1e013f07 in rl_initialize () from /usr/lib64/libreadline.so.5 > > #3 0x0000003a1e014d07 in readline () from /usr/lib64/libreadline.so.5 > > #4 0x00000038d3c4e98d in getConsoleInput () from /usr/lib64/libmal.so.0 > > #5 0x00000038d3c4f089 in readConsole () from /usr/lib64/libmal.so.0 > > #6 0x00000038d3c195ee in MALreader () from /usr/lib64/libmal.so.0 > > #7 0x00000038d3c463d6 in runScenarioBody () from /usr/lib64/libmal.so.0 > > #8 0x00000038d3c465be in runScenario () from /usr/lib64/libmal.so.0 > > #9 0x00000038d3c196f0 in MSserveClient () from /usr/lib64/libmal.so.0 > > > > Maybe FC7 RPMs cannot run on CentOS 5.1. I may try building > > manually. Thank you and sorry for the trouble. > > > > > > > >> ----- Original Message ----- > >> From: "Martin Kersten" <Martin.Kersten(a)cwi.nl> > >> To: "Communication channel for MonetDB users" > >> <monetdb-users(a)lists.sourceforge.net> > >> Subject: Re: [MonetDB-users] Cannot start mserver5 > >> Date: Fri, 28 Dec 2007 15:56:14 +0100 > >> > >> > >> Rahul, > >> > >> I seen you run as root, something one normally doesn't do, but that's > >> your decision > >> and won't affect MonetDB. > >> > >> I have no clue as what ocal configuration setting interferes with the > >> packages. > >> You might run 'gdb mserver5 --dbinit="include sql;"' and > >> sent us the stack trace. > >> > >> Rahul Chopra wrote: > >> > >>> Thank you for the clarification, I did miss that one. I have > >>> now installed it. Here is what happens now: > >>> > >>> [root@localhost bin]# mserver5 --dbinit="include sql;" > >>> # MonetDB server v5.2.2, based on kernel v1.20.0 > >>> # Serving database 'demo' > >>> # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > >>> dynamically linked > >>> # Copyright (c) 1993-2007 CWI, all rights reserved > >>> # Visit http://monetdb.cwi.nl/ for further information > >>> #warning: please don't forget to set your vault key! > >>> #(see /etc/monetdb5.conf) > >>> # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > >>> # MonetDB/SQL module v2.20.2 loaded > >>> [root@localhost bin]# > >>> > >>> It immediately exits without an error message instead of giving > >>> me a prompt. In the getting started guide it mentions to check > >>> your $PATH. It does include /usr/bin: > >>> > >>> [root@localhost bin]# echo $PATH > >>> /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > >>> > >>> Is there something else I must do? I have not changed the configuration. > >>> > >>> > >>> More info: > >>> > >>> [root@localhost bin]# rpm -ql MonetDB-SQL-server5-2.20.2-1.fc7.oid64 > >>> /usr/bin/Mbeddedsql5 > >>> /usr/bin/merovingian > >>> /usr/bin/monetdb > >>> /usr/lib64/MonetDB5/lib/lib_sql.so > >>> /usr/lib64/MonetDB5/lib/lib_sql.so.0 > >>> /usr/lib64/MonetDB5/lib/lib_sql.so.0.0.0 > >>> /usr/lib64/MonetDB5/sql.mal > >>> /usr/lib64/libembeddedsql5.so.0 > >>> /usr/lib64/libembeddedsql5.so.0.0.0 > >>> /usr/share/man/man1/merovingian.1.gz > >>> /usr/share/man/man1/monetdb.1.gz > >>> > >>> > >>> [root@localhost bin]# rpm -ql MonetDB-SQL-2.20.2-1.fc7.oid64 > >>> /usr/share/MonetDB/sql > >>> /usr/share/MonetDB/sql/bbp.sql > >>> /usr/share/MonetDB/sql/cache.sql > >>> /usr/share/MonetDB/sql/dependency_functions.sql > >>> /usr/share/MonetDB/sql/math.sql > >>> /usr/share/MonetDB/sql/ms_functions.sql > >>> /usr/share/MonetDB/sql/mtime.sql > >>> /usr/share/MonetDB/sql/stats.sql > >>> /usr/share/MonetDB/sql/url.sql > >>> /usr/share/doc/MonetDB-SQL-2.20.2 > >>> /usr/share/doc/MonetDB-SQL-2.20.2/HowToStart-SQL > >>> /usr/share/doc/MonetDB-SQL-2.20.2/HowToStart-SQL-Win32.txt > >>> /usr/share/doc/MonetDB-SQL-2.20.2/dump-restore.html > >>> /usr/share/doc/MonetDB-SQL-2.20.2/dump-restore.txt > >>> > >>> [root@localhost bin]# mserver5 --xproperties > >>> # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu > >>> # builtin opt gdk_version = 1.20.0 > >>> # builtin opt monet_pid = 23171 > >>> # builtin opt prefix = /usr > >>> # builtin opt exec_prefix = /usr > >>> # builtin opt gdk_dbname = tst > >>> # builtin opt gdk_dbfarm = /var/MonetDB > >>> # builtin opt gdk_debug = 8 > >>> # builtin opt gdk_mem_bigsize = 262144 > >>> # builtin opt gdk_vm_minsize = 137438953472 > >>> # builtin opt gdk_alloc_map = yes > >>> # builtin opt gdk_mem_pagebits = 14 > >>> # builtin opt gdk_vmtrim = yes > >>> # builtin opt monet_admin = adm > >>> # builtin opt monet_prompt = > > >>> # builtin opt monet_welcome = yes > >>> # builtin opt monet_mod_path = /usr/lib64/MonetDB:/usr/lib64/bin > >>> # builtin opt monet_daemon = yes > >>> # builtin opt host = localhost > >>> # builtin opt mapi_port = 50000 > >>> # builtin opt mapi_noheaders = no > >>> # builtin opt mapi_debug = 0 > >>> # builtin opt mapi_clients = 2 > >>> # builtin opt sql_debug = 0 > >>> # builtin opt sql_logdir = /var/MonetDB/sql_logs > >>> # builtin opt xquery_logdir = /var/MonetDB/xquery_logs > >>> # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > >>> # builtin opt standoff_start = start > >>> # builtin opt standoff_end = end > >>> # config opt prefix = /usr > >>> # config opt config = /etc/monetdb5.conf > >>> # config opt prefix = /usr > >>> # config opt exec_prefix = /usr > >>> # config opt gdk_dbfarm = /var/MonetDB5/dbfarm > >>> # config opt gdk_dbname = demo > >>> # config opt gdk_alloc_map = no > >>> # config opt gdk_embedded = no > >>> # config opt gdk_debug = 0 > >>> # config opt monet_mod_path = > >>> /usr/lib64/MonetDB5:/usr/lib64/MonetDB5/lib:/usr/lib64/MonetDB5/bin > >>> # config opt monet_daemon = no > >>> # config opt monet_welcome = yes > >>> # config opt mero_msglog = /var/log/merovingian.log > >>> # config opt mero_errlog = /var/log/merovingian.log > >>> # config opt mero_timeinterval = 600 > >>> # config opt mero_exittimeout = 7 > >>> # config opt mal_init = /usr/lib64/MonetDB5/mal_init.mal > >>> # config opt mal_listing = 15 > >>> # config opt checkpoint_dir = /var/MonetDB5/chkpnt > >>> # config opt mapi_port = 0 > >>> # config opt mapi_open = false > >>> # config opt sql_debug = 0 > >>> # config opt sql_logdir = /var/MonetDB5/sql_logs > >>> # config opt sql_init = /usr/lib64/MonetDB5/sql_init.sql > >>> # MonetDB server v5.2.2, based on kernel v1.20.0 > >>> # Serving database 'demo' > >>> # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > >>> dynamically linked > >>> # Copyright (c) 1993-2007 CWI, all rights reserved > >>> # Visit http://monetdb.cwi.nl/ for further information > >>> #warning: please don't forget to set your vault key! > >>> #(see /etc/monetdb5.conf) > >>> # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > >>> [root@localhost bin]# > >>> > >>> > >>> > >>> > >>> > >>>> ----- Original Message ----- > >>>> From: "Niels Nes" <Niels.Nes(a)cwi.nl> > >>>> To: "Communication channel for MonetDB users" > >>>> <monetdb-users(a)lists.sourceforge.net> > >>>> Subject: Re: [MonetDB-users] Cannot start mserver5 > >>>> Date: Fri, 28 Dec 2007 09:44:56 +0100 > >>>> > >>>> > >>>> On Fri, Dec 28, 2007 at 08:16:45AM +0800, Rahul Chopra wrote: > >>>> > >>>> > >>>>> Hello, > >>>>> > >>>>> I installed a copy of MonetDB on CentOS 5.1, but don't seem > >>>>> to be able to start it. I installed the RPMs, and then wanted > >>>>> to follow the "Getting Started" page on your website. > >>>>> > >>>>> > >>>>> [root@localhost ~]# mserver5 --dbinit="include sql;" > >>>>> # MonetDB server v5.2.2, based on kernel v1.20.0 > >>>>> # Serving database 'demo' > >>>>> # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > >>>>> dynamically linked > >>>>> # Copyright (c) 1993-2007 CWI, all rights reserved > >>>>> # Visit http://monetdb.cwi.nl/ for further information > >>>>> #warning: please don't forget to set your vault key! > >>>>> #(see /etc/monetdb5.conf) > >>>>> # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > >>>>> !MALException:malInclude:could not open file: sql > >>>>> > >>>>> [root@localhost ~]# uname -a > >>>>> Linux localhost.localdomain 2.6.18-53.el5xen #1 SMP Mon Nov > >>>>> 12 02:46:57 EST 2007 x86_64 x86_64 x86_64 GNU/Linux > >>>>> > >>>>> [root@localhost ~]# rpm -qa | grep MonetDB > >>>>> MonetDB-client-1.20.2-1.fc7.oid64 > >>>>> MonetDB-1.20.0-3.fc7.oid64 > >>>>> MonetDB-SQL-2.20.2-1.fc7.oid64 > >>>>> MonetDB5-server-5.2.2-1.fc7.oid64 > >>>>> > >>>>> Any idea what I am doing wrong? > >>>>> > >>>>> > >>>> You need to also install the MonetDB-SQL-server5 rpm > >>>> > >>>> Niels > >>>> > >>>> > >>>> > >>>> > >>>>> Regards, > >>>>> > >>>>> Rahul > >>>>> > >>>>> > >>>>> > >>>>> = > >>>>> Criminal Justice Degrees > >>>>> Online Criminal Justice studies - Free info pack now. > >>>>> http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=c47df44e10a9717326d9f94… > >>>>> > >>>>> > >>>>> -- Powered by Outblaze > >>>>> > >>>>> ------------------------------------------------------------------------- > >>>>> This SF.net email is sponsored by: Microsoft > >>>>> Defy all challenges. Microsoft(R) Visual Studio 2005. > >>>>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >>>>> _______________________________________________ > >>>>> MonetDB-users mailing list > >>>>> MonetDB-users(a)lists.sourceforge.net > >>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >>>>> > >>>>> > >>>> -- > >>>> > >>>> Niels Nes, Centre for Mathematics and Computer Science (CWI) > >>>> Kruislaan 413, 1098 SJ Amsterdam, The Netherlands > >>>> room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 > >>>> url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl > >>>> > >>>> ------------------------------------------------------------------------- > >>>> This SF.net email is sponsored by: Microsoft > >>>> Defy all challenges. Microsoft(R) Visual Studio 2005. > >>>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >>>> _______________________________________________ > >>>> MonetDB-users mailing list > >>>> MonetDB-users(a)lists.sourceforge.net > >>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >>>> > >>>> > >>> > >>> > >>> = > >>> Looking for HR Software? > >>> BillQuick HR will help you manage your employees more efficiently. > >>> http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=a512cd91e758d3cf866e8fb… > >>> > >>> > >>> > >>> > >> ------------------------------------------------------------------------- > >> This SF.net email is sponsored by: Microsoft > >> Defy all challenges. Microsoft(R) Visual Studio 2005. > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> _______________________________________________ > >> MonetDB-users mailing list > >> MonetDB-users(a)lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > > > > > > > > > > = > > Illinois Real Estate > > Search approximately 80,000 listings - easy to use and consumer-friendly. > > http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=cd5e8640812a8f246564650… > > > > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > = Aliante - Las Vegas Valley, Nevada Welcome to the beautiful new residential master-planned community of Aliante. Browse our site to see a community map, community resources, descriptions and builder information. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=1b166d271bb74530d5618e7… = Battery Backups from $25 Huge bargains on UPS power backup systems. Hundreds in stock. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=fcec83cbfc8a5226862cb33… -- Powered by Outblaze

1 0

Re: [MonetDB-users] Cannot start mserver5
by Rahul Chopra 28 Dec '07

28 Dec '07

Hi Martin, I am now running as a non-root user. Here is the output from the stack trace: Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 46912496255632 (LWP 23889)] 0x0000000000000000 in ?? () (gdb) bt #0 0x0000000000000000 in ?? () #1 0x0000003a1e026d9e in _rl_init_terminal_io () from /usr/lib64/libreadline.so.5 #2 0x0000003a1e013f07 in rl_initialize () from /usr/lib64/libreadline.so.5 #3 0x0000003a1e014d07 in readline () from /usr/lib64/libreadline.so.5 #4 0x00000038d3c4e98d in getConsoleInput () from /usr/lib64/libmal.so.0 #5 0x00000038d3c4f089 in readConsole () from /usr/lib64/libmal.so.0 #6 0x00000038d3c195ee in MALreader () from /usr/lib64/libmal.so.0 #7 0x00000038d3c463d6 in runScenarioBody () from /usr/lib64/libmal.so.0 #8 0x00000038d3c465be in runScenario () from /usr/lib64/libmal.so.0 #9 0x00000038d3c196f0 in MSserveClient () from /usr/lib64/libmal.so.0 Maybe FC7 RPMs cannot run on CentOS 5.1. I may try building manually. Thank you and sorry for the trouble. > ----- Original Message ----- > From: "Martin Kersten" <Martin.Kersten(a)cwi.nl> > To: "Communication channel for MonetDB users" <monetdb-users(a)lists.sourceforge.net> > Subject: Re: [MonetDB-users] Cannot start mserver5 > Date: Fri, 28 Dec 2007 15:56:14 +0100 > > > Rahul, > > I seen you run as root, something one normally doesn't do, but that's > your decision > and won't affect MonetDB. > > I have no clue as what ocal configuration setting interferes with the > packages. > You might run 'gdb mserver5 --dbinit="include sql;"' and > sent us the stack trace. > > Rahul Chopra wrote: > > Thank you for the clarification, I did miss that one. I have now > > installed it. Here is what happens now: > > > > [root@localhost bin]# mserver5 --dbinit="include sql;" > > # MonetDB server v5.2.2, based on kernel v1.20.0 > > # Serving database 'demo' > > # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > > dynamically linked > > # Copyright (c) 1993-2007 CWI, all rights reserved > > # Visit http://monetdb.cwi.nl/ for further information > > #warning: please don't forget to set your vault key! > > #(see /etc/monetdb5.conf) > > # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > > # MonetDB/SQL module v2.20.2 loaded > > [root@localhost bin]# > > > > It immediately exits without an error message instead of giving > > me a prompt. In the getting started guide it mentions to check > > your $PATH. It does include /usr/bin: > > > > [root@localhost bin]# echo $PATH > > /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin > > > > Is there something else I must do? I have not changed the configuration. > > > > > > More info: > > > > [root@localhost bin]# rpm -ql MonetDB-SQL-server5-2.20.2-1.fc7.oid64 > > /usr/bin/Mbeddedsql5 > > /usr/bin/merovingian > > /usr/bin/monetdb > > /usr/lib64/MonetDB5/lib/lib_sql.so > > /usr/lib64/MonetDB5/lib/lib_sql.so.0 > > /usr/lib64/MonetDB5/lib/lib_sql.so.0.0.0 > > /usr/lib64/MonetDB5/sql.mal > > /usr/lib64/libembeddedsql5.so.0 > > /usr/lib64/libembeddedsql5.so.0.0.0 > > /usr/share/man/man1/merovingian.1.gz > > /usr/share/man/man1/monetdb.1.gz > > > > > > [root@localhost bin]# rpm -ql MonetDB-SQL-2.20.2-1.fc7.oid64 > > /usr/share/MonetDB/sql > > /usr/share/MonetDB/sql/bbp.sql > > /usr/share/MonetDB/sql/cache.sql > > /usr/share/MonetDB/sql/dependency_functions.sql > > /usr/share/MonetDB/sql/math.sql > > /usr/share/MonetDB/sql/ms_functions.sql > > /usr/share/MonetDB/sql/mtime.sql > > /usr/share/MonetDB/sql/stats.sql > > /usr/share/MonetDB/sql/url.sql > > /usr/share/doc/MonetDB-SQL-2.20.2 > > /usr/share/doc/MonetDB-SQL-2.20.2/HowToStart-SQL > > /usr/share/doc/MonetDB-SQL-2.20.2/HowToStart-SQL-Win32.txt > > /usr/share/doc/MonetDB-SQL-2.20.2/dump-restore.html > > /usr/share/doc/MonetDB-SQL-2.20.2/dump-restore.txt > > > > [root@localhost bin]# mserver5 --xproperties > > # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu > > # builtin opt gdk_version = 1.20.0 > > # builtin opt monet_pid = 23171 > > # builtin opt prefix = /usr > > # builtin opt exec_prefix = /usr > > # builtin opt gdk_dbname = tst > > # builtin opt gdk_dbfarm = /var/MonetDB > > # builtin opt gdk_debug = 8 > > # builtin opt gdk_mem_bigsize = 262144 > > # builtin opt gdk_vm_minsize = 137438953472 > > # builtin opt gdk_alloc_map = yes > > # builtin opt gdk_mem_pagebits = 14 > > # builtin opt gdk_vmtrim = yes > > # builtin opt monet_admin = adm > > # builtin opt monet_prompt = > > > # builtin opt monet_welcome = yes > > # builtin opt monet_mod_path = /usr/lib64/MonetDB:/usr/lib64/bin > > # builtin opt monet_daemon = yes > > # builtin opt host = localhost > > # builtin opt mapi_port = 50000 > > # builtin opt mapi_noheaders = no > > # builtin opt mapi_debug = 0 > > # builtin opt mapi_clients = 2 > > # builtin opt sql_debug = 0 > > # builtin opt sql_logdir = /var/MonetDB/sql_logs > > # builtin opt xquery_logdir = /var/MonetDB/xquery_logs > > # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > > # builtin opt standoff_start = start > > # builtin opt standoff_end = end > > # config opt prefix = /usr > > # config opt config = /etc/monetdb5.conf > > # config opt prefix = /usr > > # config opt exec_prefix = /usr > > # config opt gdk_dbfarm = /var/MonetDB5/dbfarm > > # config opt gdk_dbname = demo > > # config opt gdk_alloc_map = no > > # config opt gdk_embedded = no > > # config opt gdk_debug = 0 > > # config opt monet_mod_path = > > /usr/lib64/MonetDB5:/usr/lib64/MonetDB5/lib:/usr/lib64/MonetDB5/bin > > # config opt monet_daemon = no > > # config opt monet_welcome = yes > > # config opt mero_msglog = /var/log/merovingian.log > > # config opt mero_errlog = /var/log/merovingian.log > > # config opt mero_timeinterval = 600 > > # config opt mero_exittimeout = 7 > > # config opt mal_init = /usr/lib64/MonetDB5/mal_init.mal > > # config opt mal_listing = 15 > > # config opt checkpoint_dir = /var/MonetDB5/chkpnt > > # config opt mapi_port = 0 > > # config opt mapi_open = false > > # config opt sql_debug = 0 > > # config opt sql_logdir = /var/MonetDB5/sql_logs > > # config opt sql_init = /usr/lib64/MonetDB5/sql_init.sql > > # MonetDB server v5.2.2, based on kernel v1.20.0 > > # Serving database 'demo' > > # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > > dynamically linked > > # Copyright (c) 1993-2007 CWI, all rights reserved > > # Visit http://monetdb.cwi.nl/ for further information > > #warning: please don't forget to set your vault key! > > #(see /etc/monetdb5.conf) > > # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > > [root@localhost bin]# > > > > > > > > > >> ----- Original Message ----- > >> From: "Niels Nes" <Niels.Nes(a)cwi.nl> > >> To: "Communication channel for MonetDB users" > >> <monetdb-users(a)lists.sourceforge.net> > >> Subject: Re: [MonetDB-users] Cannot start mserver5 > >> Date: Fri, 28 Dec 2007 09:44:56 +0100 > >> > >> > >> On Fri, Dec 28, 2007 at 08:16:45AM +0800, Rahul Chopra wrote: > >> > >>> Hello, > >>> > >>> I installed a copy of MonetDB on CentOS 5.1, but don't seem to > >>> be able to start it. I installed the RPMs, and then wanted to > >>> follow the "Getting Started" page on your website. > >>> > >>> > >>> [root@localhost ~]# mserver5 --dbinit="include sql;" > >>> # MonetDB server v5.2.2, based on kernel v1.20.0 > >>> # Serving database 'demo' > >>> # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > >>> dynamically linked > >>> # Copyright (c) 1993-2007 CWI, all rights reserved > >>> # Visit http://monetdb.cwi.nl/ for further information > >>> #warning: please don't forget to set your vault key! > >>> #(see /etc/monetdb5.conf) > >>> # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > >>> !MALException:malInclude:could not open file: sql > >>> > >>> [root@localhost ~]# uname -a > >>> Linux localhost.localdomain 2.6.18-53.el5xen #1 SMP Mon Nov 12 > >>> 02:46:57 EST 2007 x86_64 x86_64 x86_64 GNU/Linux > >>> > >>> [root@localhost ~]# rpm -qa | grep MonetDB > >>> MonetDB-client-1.20.2-1.fc7.oid64 > >>> MonetDB-1.20.0-3.fc7.oid64 > >>> MonetDB-SQL-2.20.2-1.fc7.oid64 > >>> MonetDB5-server-5.2.2-1.fc7.oid64 > >>> > >>> Any idea what I am doing wrong? > >>> > >> You need to also install the MonetDB-SQL-server5 rpm > >> > >> Niels > >> > >> > >> > >>> Regards, > >>> > >>> Rahul > >>> > >>> > >>> > >>> = > >>> Criminal Justice Degrees > >>> Online Criminal Justice studies - Free info pack now. > >>> http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=c47df44e10a9717326d9f94… > >>> > >>> > >>> -- Powered by Outblaze > >>> > >>> ------------------------------------------------------------------------- > >>> This SF.net email is sponsored by: Microsoft > >>> Defy all challenges. Microsoft(R) Visual Studio 2005. > >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >>> _______________________________________________ > >>> MonetDB-users mailing list > >>> MonetDB-users(a)lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >>> > >> -- > >> > >> Niels Nes, Centre for Mathematics and Computer Science (CWI) > >> Kruislaan 413, 1098 SJ Amsterdam, The Netherlands > >> room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 > >> url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl > >> > >> ------------------------------------------------------------------------- > >> This SF.net email is sponsored by: Microsoft > >> Defy all challenges. Microsoft(R) Visual Studio 2005. > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> _______________________________________________ > >> MonetDB-users mailing list > >> MonetDB-users(a)lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > > > > > > > > > > = > > Looking for HR Software? > > BillQuick HR will help you manage your employees more efficiently. > > http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=a512cd91e758d3cf866e8fb… > > > > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > = Illinois Real Estate Search approximately 80,000 listings - easy to use and consumer-friendly. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=cd5e8640812a8f246564650… -- Powered by Outblaze

2 1

Re: [MonetDB-users] Cannot start mserver5
by Rahul Chopra 28 Dec '07

28 Dec '07

Thank you for the clarification, I did miss that one. I have now installed it. Here is what happens now: [root@localhost bin]# mserver5 --dbinit="include sql;" # MonetDB server v5.2.2, based on kernel v1.20.0 # Serving database 'demo' # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.20.2 loaded [root@localhost bin]# It immediately exits without an error message instead of giving me a prompt. In the getting started guide it mentions to check your $PATH. It does include /usr/bin: [root@localhost bin]# echo $PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin Is there something else I must do? I have not changed the configuration. More info: [root@localhost bin]# rpm -ql MonetDB-SQL-server5-2.20.2-1.fc7.oid64 /usr/bin/Mbeddedsql5 /usr/bin/merovingian /usr/bin/monetdb /usr/lib64/MonetDB5/lib/lib_sql.so /usr/lib64/MonetDB5/lib/lib_sql.so.0 /usr/lib64/MonetDB5/lib/lib_sql.so.0.0.0 /usr/lib64/MonetDB5/sql.mal /usr/lib64/libembeddedsql5.so.0 /usr/lib64/libembeddedsql5.so.0.0.0 /usr/share/man/man1/merovingian.1.gz /usr/share/man/man1/monetdb.1.gz [root@localhost bin]# rpm -ql MonetDB-SQL-2.20.2-1.fc7.oid64 /usr/share/MonetDB/sql /usr/share/MonetDB/sql/bbp.sql /usr/share/MonetDB/sql/cache.sql /usr/share/MonetDB/sql/dependency_functions.sql /usr/share/MonetDB/sql/math.sql /usr/share/MonetDB/sql/ms_functions.sql /usr/share/MonetDB/sql/mtime.sql /usr/share/MonetDB/sql/stats.sql /usr/share/MonetDB/sql/url.sql /usr/share/doc/MonetDB-SQL-2.20.2 /usr/share/doc/MonetDB-SQL-2.20.2/HowToStart-SQL /usr/share/doc/MonetDB-SQL-2.20.2/HowToStart-SQL-Win32.txt /usr/share/doc/MonetDB-SQL-2.20.2/dump-restore.html /usr/share/doc/MonetDB-SQL-2.20.2/dump-restore.txt [root@localhost bin]# mserver5 --xproperties # builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu # builtin opt gdk_version = 1.20.0 # builtin opt monet_pid = 23171 # builtin opt prefix = /usr # builtin opt exec_prefix = /usr # builtin opt gdk_dbname = tst # builtin opt gdk_dbfarm = /var/MonetDB # builtin opt gdk_debug = 8 # builtin opt gdk_mem_bigsize = 262144 # builtin opt gdk_vm_minsize = 137438953472 # builtin opt gdk_alloc_map = yes # builtin opt gdk_mem_pagebits = 14 # builtin opt gdk_vmtrim = yes # builtin opt monet_admin = adm # builtin opt monet_prompt = > # builtin opt monet_welcome = yes # builtin opt monet_mod_path = /usr/lib64/MonetDB:/usr/lib64/bin # builtin opt monet_daemon = yes # builtin opt host = localhost # builtin opt mapi_port = 50000 # builtin opt mapi_noheaders = no # builtin opt mapi_debug = 0 # builtin opt mapi_clients = 2 # builtin opt sql_debug = 0 # builtin opt sql_logdir = /var/MonetDB/sql_logs # builtin opt xquery_logdir = /var/MonetDB/xquery_logs # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff # builtin opt standoff_start = start # builtin opt standoff_end = end # config opt prefix = /usr # config opt config = /etc/monetdb5.conf # config opt prefix = /usr # config opt exec_prefix = /usr # config opt gdk_dbfarm = /var/MonetDB5/dbfarm # config opt gdk_dbname = demo # config opt gdk_alloc_map = no # config opt gdk_embedded = no # config opt gdk_debug = 0 # config opt monet_mod_path = /usr/lib64/MonetDB5:/usr/lib64/MonetDB5/lib:/usr/lib64/MonetDB5/bin # config opt monet_daemon = no # config opt monet_welcome = yes # config opt mero_msglog = /var/log/merovingian.log # config opt mero_errlog = /var/log/merovingian.log # config opt mero_timeinterval = 600 # config opt mero_exittimeout = 7 # config opt mal_init = /usr/lib64/MonetDB5/mal_init.mal # config opt mal_listing = 15 # config opt checkpoint_dir = /var/MonetDB5/chkpnt # config opt mapi_port = 0 # config opt mapi_open = false # config opt sql_debug = 0 # config opt sql_logdir = /var/MonetDB5/sql_logs # config opt sql_init = /usr/lib64/MonetDB5/sql_init.sql # MonetDB server v5.2.2, based on kernel v1.20.0 # Serving database 'demo' # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ [root@localhost bin]# > ----- Original Message ----- > From: "Niels Nes" <Niels.Nes(a)cwi.nl> > To: "Communication channel for MonetDB users" <monetdb-users(a)lists.sourceforge.net> > Subject: Re: [MonetDB-users] Cannot start mserver5 > Date: Fri, 28 Dec 2007 09:44:56 +0100 > > > On Fri, Dec 28, 2007 at 08:16:45AM +0800, Rahul Chopra wrote: > > Hello, > > > > I installed a copy of MonetDB on CentOS 5.1, but don't seem to be > > able to start it. I installed the RPMs, and then wanted to follow > > the "Getting Started" page on your website. > > > > > > [root@localhost ~]# mserver5 --dbinit="include sql;" > > # MonetDB server v5.2.2, based on kernel v1.20.0 > > # Serving database 'demo' > > # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs > > dynamically linked > > # Copyright (c) 1993-2007 CWI, all rights reserved > > # Visit http://monetdb.cwi.nl/ for further information > > #warning: please don't forget to set your vault key! > > #(see /etc/monetdb5.conf) > > # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > > !MALException:malInclude:could not open file: sql > > > > [root@localhost ~]# uname -a > > Linux localhost.localdomain 2.6.18-53.el5xen #1 SMP Mon Nov 12 > > 02:46:57 EST 2007 x86_64 x86_64 x86_64 GNU/Linux > > > > [root@localhost ~]# rpm -qa | grep MonetDB > > MonetDB-client-1.20.2-1.fc7.oid64 > > MonetDB-1.20.0-3.fc7.oid64 > > MonetDB-SQL-2.20.2-1.fc7.oid64 > > MonetDB5-server-5.2.2-1.fc7.oid64 > > > > Any idea what I am doing wrong? > You need to also install the MonetDB-SQL-server5 rpm > > Niels > > > > > > Regards, > > > > Rahul > > > > > > > > = > > Criminal Justice Degrees > > Online Criminal Justice studies - Free info pack now. > > http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=c47df44e10a9717326d9f94… > > > > > > -- Powered by Outblaze > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > MonetDB-users mailing list > > MonetDB-users(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > -- > > Niels Nes, Centre for Mathematics and Computer Science (CWI) > Kruislaan 413, 1098 SJ Amsterdam, The Netherlands > room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 > url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > = Looking for HR Software? BillQuick HR will help you manage your employees more efficiently. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=a512cd91e758d3cf866e8fb… -- Powered by Outblaze

2 1

[MonetDB-users] Cannot start mserver5
by Rahul Chopra 28 Dec '07

28 Dec '07

Hello, I installed a copy of MonetDB on CentOS 5.1, but don't seem to be able to start it. I installed the RPMs, and then wanted to follow the "Getting Started" page on your website. [root@localhost ~]# mserver5 --dbinit="include sql;" # MonetDB server v5.2.2, based on kernel v1.20.0 # Serving database 'demo' # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ !MALException:malInclude:could not open file: sql [root@localhost ~]# uname -a Linux localhost.localdomain 2.6.18-53.el5xen #1 SMP Mon Nov 12 02:46:57 EST 2007 x86_64 x86_64 x86_64 GNU/Linux [root@localhost ~]# rpm -qa | grep MonetDB MonetDB-client-1.20.2-1.fc7.oid64 MonetDB-1.20.0-3.fc7.oid64 MonetDB-SQL-2.20.2-1.fc7.oid64 MonetDB5-server-5.2.2-1.fc7.oid64 Any idea what I am doing wrong? Regards, Rahul = Criminal Justice Degrees Online Criminal Justice studies - Free info pack now. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=c47df44e10a9717326d9f94… -- Powered by Outblaze

3 2

[MonetDB-users] Benchmark on MonetDB/X100
by Konstantinos Krikellas 26 Dec '07

26 Dec '07

I want to use MonetDB for benchmarking on the TPC-H workload. According to the paper "MonetDB/X100 - A DBMS In The CPU Cache", the X100 module achieves significant acceleration against MonetDB/MIL on Query 1 of TPC-H. Still, when I search your site, there is no reference about how it is possible to activate X100 inside MonetDB. I have only found X100 in your repository for mserver5 in Sourceforge, but it is not currently active. Therefore, I have the following questions: a) Has X100 been integrated to the Mserver5 version of MonetDB, or included as an extension module? b) Does Mserver5 use vector processing as proposed in the paper "MonetDB/X100: Hyper-Pipelining Query Execution" (CIDR 2005) ? c) How is it possible to use MonetDB/X100 for benchmarking purposes? Are there any instructions online? Thank you.

2 1

[MonetDB-users] Memory leaks on nightly stable
by m h 22 Dec '07

22 Dec '07

Hey all- I've been benchmarking my application against mysql and postgres. For my test application which has some 1Mil rows of data and my sample query that returns some 260K rows here's some stats. Speed for query: Postgres 15 sec (8.1) Monetdb 33 sec (nightly stable) Mysql 100 sec (5.0) Bulk load speed: Postgres 12 Min Monetdb 1 Min Mysql 2 Min Memory during bulk load: Postgres 20 Meg Monetdb 700 Meg!!! (And it doesn't come back down) Mysql 20 Meg Memory during query: Postgres 30Meg Monetdb 180 Meg (And increases by 10-20 Meg /query) Mysql 30 Meg Niels has some trick up his sleeves that bring the query speed down (using the nightly current). But I'm concerned about memory use. It's fine to use memory if you are going to be fast. But if I can't load my data (in all I have 67+ mil rows) or have to restart the server after a few queries it is problematic. I've submitted bugs with valgrind reports during load/query, but am wondering if other steps can be taken to help with the memory issue? I know that both mysql and postgres (and a host of other open source projects) have benefitted from coverity's offering [0] and klocworks [1] as well. Have these been looked into? It might be worth it have some automated "eyes" along with the "many eyes" of the open source community that make all bugs shallow. Some food for thought cheers, -matt 0 - http://scan.coverity.com/ 1 - http://www.klocwork.com/company/releases/06_26_06.asp

2 2