- users-list - monetdb.org

[MonetDB-users] MonetDb comparison Data Load
by Prometheus WillSurvive 19 Jan '09

19 Jan '09

Dear Developers-Users, First of all I would like to thanks all of your afforts to birng us these DB technologies and a platform for openly discussion. We are consulting big sized customers and deploying their data search technologies. Total size is around 1 petabytes daily . (total of our customers number ) . Their data size starts 1 TB (9.000.000.000 lines cvs) to 100 TB. so we have different size of customer base. We are looking opensource db solutions for a while due to lack of support … [View More]

1 0

[MonetDB-users] Are there binary rpm install files for Red Hat Enterprise Linux?
by 小波顾 17 Jan '09

17 Jan '09

_________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

1 0

[MonetDB-users] Copy from file which contains Chinese characters failed.
by 小波顾 17 Jan '09

17 Jan '09

Copy from file which contains Chinese characters failed. My test table is create table t1(a int not null primary key, b varchar(1024)); My test file d:\data.txt contains two lines1,测试12,测试2 I have tried to save the data file using ANSI and UTF8 encoding using Notepad on windows,and tried to start mclient with -Ecp437, -Ecp936 and -Eutf-8 option, neither combination of thefile encoding and mclient encoding can load the file correctlly. When both using utf-8 the following error messages appears:… [View More]

3 8

[MonetDB-users] Can't connect to remote MonetDB5-SQL Server.
by 小波顾 17 Jan '09

17 Jan '09

I have installed all the rpms in my Fedora9 virtual machine: 2009-01-17 12:07 3,339,229 MonetDB-1.26.2-1.fc9.oid32.i386.rpm2009-01-17 12:07 84,115 MonetDB-client-1.26.2-1.fc9.oid32.i386.rpm2009-01-17 12:37 7,988 MonetDB-SQL-2.26.2-1.fc9.oid32.i386.rpm2009-01-17 12:36 873,636 MonetDB-SQL-server5-2.26.2-1.fc9.oid32.i386.rpm2009-01-14 22:07 5,054,522 MonetDB5-server-5.8.2-1.fc9.oid32.i386.rpmAnd using the following steps recreated the demo … [View More]

1 1

[MonetDB-users] SIGBUS on mserver5 after large load.
by Schwarz, Omri 16 Jan '09

16 Jan '09

I have a large database that loads nicely on MonetDB from MySQL when it'd done with INSERTs with one row at a time. But when I group them in sets of 300 or so, for any reason, i.e. INSERT INTO TABLE VALUES (FOO), (BAR) ... ; it develops a memory leak which is not helped by setting gdk_mem_bigsize or gdk_vm_minsize. And when that makes me abort the load, the result is that backend data are corrupted. I can start the database server, but on the first connection attempt, this happens: [pid … [View More]

1 0

[MonetDB-users] Python client strangeness.
by Schwarz, Omri 15 Jan '09

15 Jan '09

when you set "gdk_debug" to 4 (for memory debugging), it causes the server to give empty lists to "select * from tables;" queries coming from Python DB API clients, but not when they come from mclient. Denham Quantitative Management LP 200 Clarendon Street, 25th Floor Boston, MA 02216 T: 617-587-5812 M: 617-909-7786 omri.schwarz(a)denhamcapital.com NOTICE: This e-mail message is intended for the named recipient(s) above and may contain confidential information. If you are not the … [View More]

1 0

[MonetDB-users] Building clients - php and perl dependencies
by David Svenson 15 Jan '09

15 Jan '09

Hi, I am trying to build MonetDB on windows, and so far I have successfully built 'buildtoos' and 'MonetDB' from the CVS. Now I'm trying to build 'clients' without PHP or PERL, but I'm having difficulties. The documentation says that only Phyton is required, however, I still get build errors related to perl and php dependencies. I do not set HAVE_PERL=1 or HAVE_PHP=1, and therefor expect the build not to rely on them. Am I missing something? Is there something else I need to do in order to … [View More]

2 3

[MonetDB-users] MALException:MAL.getAddress:address of 'bat.BKChasReadMode' not found (followup)
by Schwarz, Omri 15 Jan '09

15 Jan '09

I found the problem: the linker was silently balking at creating the .sos and not telling 'make' about it, so a full build was done without the shared libraries. It's a GNU linker/autoconf issue that the MonetDB team can't do much about besides posting this email where Google will find it, but thank you all for helping me diagnose the issue. Now I just have to work with the memory leak I'm seeing. I see I can log all memory operations, but where can I set memory usage to be limited … [View More]

1 0

[MonetDB-users] MALException:MAL.getAddress:address of 'bat.BKChasReadMode' not found (followup)
by Schwarz, Omri 14 Jan '09

14 Jan '09

Making some progress. Starting with a fresh merovingian process, I did an "strace -fe file,process -p PID] on it. "monetdb create test" did nothing, but "start test" shows it opens the dbfarm directory, and mal_init.mal, but then fails to find any of the MonetDB5 .sos [excriciating scroll included below] because only the .a and .la files got installed there. The build tree is also stripped of .sos. [root@mork MonetDBFast]# ls lib/MonetDB5/lib lib_aggr.a lib_batifthen.… [View More]

1 0

Re: [MonetDB-users] PF: "Group By" work-around no longer working?
by Jan Rittinger 14 Jan '09

14 Jan '09

On Jan 14, 2009, at 11:53, jz@uva wrote: > Hi Jan, > > I was also using the GROUP BY construct. > This is my query: ... > let $qid := tijah:queryall-id($query_nexi, $options) > let $nodes := tijah:nodes($qid) > let $result := for $node in $nodes > return > typeswitch ($node) > case $elem-node as element(*) > return > <result> > <num> { (count($node/$elem-node/preceding::*) + 1) + This snippet of XQuery is to complex: '… [View More]count($node/$elem-node/...'. Both $node and $elem-node contain the tijah-result nodes (with type node() and element(*), respectively). What you want to write is 'count($elem-node/...'. > > > string-length(tijah:getINEXPath($node)) } </num> > <file> { data($node/$elem-node/ancestor-or-self::EAD/@FILE) } </ > file> > <title> { data($node/$elem-node/ancestor-or-self::EAD/@TITLE) } > </title> ... > > <score> { tijah:score($qid, $node/$elem-node) } </score> > </result> > default return error ("unexpected node") > > let $total := count($result) > return <results total="{$total}"> { > for $res at $rankGlobal in distinct-values($result/file) > let $cs-group := $result[file = $res] > for $cs-group2 at $rank in $cs-group > where exists($cs-group2) this line is unnecessary as there is always exactly one item bound to $cs-group2. > > and $rank >= 1 this line is unnecessary as the positional variable always starts from 1 (and can never be less). > > and $rank <= 8 > and $rankGlobal >= $start > and $rankGlobal <= $end > order by $cs-group2 cast as xs:integer what do you want here? I very much doubt that you are able to atomize an XML snippet, then cast the string-value into a number and still get something meaningful out. > > return > <out id="{$res}">{ $cs-group2 }</out> > } </results> > > With this query, I get different results in MPS and Alg. I guess MPS treats your order by differently---read incorrectly---by ignoring every character data after the first number which accidently is the content of element num. Perhaps your query already works the way you expect it by replacing the ORDER BY by the following snippet: 'order by number($cs-group2/ num)'. Jan -- Jan Rittinger Lehrstuhl Datenbanken und Informationssysteme Wilhelm-Schickard-Institut für Informatik Eberhard-Karls-Universität Tübingen http://www-db.informatik.uni-tuebingen.de/team/rittinger [View Less]

3 3

[MonetDB-users] Monetdb source rpm install failed on Fedora 6.
by 小波顾 14 Jan '09

14 Jan '09

Now I am trying to install MonetDB5 on a Fedora 6 virtual machine, the source rpm I am using is MonetDB5-server-5.8.2-1.src.rpm, The following error messages was thrown when I enter rpm -i MonetDB5-server-5.8.2-1.src.rpm as root: [root@host01 monetdb5]# rpm -i MonetDB5-server-5.8.2-1.src.rpm warning: MonetDB5-server-5.8.2-1.src.rpm: Header V3 DSA signature: NOKEY, key ID 0583366fwarning: user sjoerd does not exist - using rootwarning: group sjoerd does not exist - using rootwarning: user … [View More]

3 2

[MonetDB-users] MALException:MAL.getAddress:address of 'bat.BKChasReadMode' not found
by Schwarz, Omri 14 Jan '09

14 Jan '09

I am trying to do a straight install of Monet's latest SuperBall (SP!) on Centos 5 (64 bits) and so here is the prologue to the build log: called with arguments: --enable-sql --enable-optimise --prefix=/var/tmp/TEST Copying /root/MonetDB-Nov2008-SuperBall-SP1/MonetDB to /var/tmp/MonetDB-1231879854 Copying /root/MonetDB-Nov2008-SuperBall-SP1/MonetDB-client to /var/tmp/MonetDB-1231879854 Copying /root/MonetDB-Nov2008-SuperBall-SP1/MonetDB5-server to /var/tmp/MonetDB-1231879854 Copying /root/… [View More]MonetDB-Nov2008-SuperBall-SP1/MonetDB-SQL to /var/tmp/MonetDB-1231879854 * Processing MonetDB ./configure --prefix='/var/tmp/TEST' --enable-optimize --disable-debug --disable-assert --disable-strict --with-python-libdir=lib64/python2.5 --with-p ython-library=/usr/local/lib64/ --with-python-incdir=/usr/local/include/python2.5 The process completes and installs, but when merovingian tries to start a database, it logs this: MSG merovingian[17999]: refresh from mork.denhamcapital.corp for database TEST2 MSG merovingian[17999]: refresh from mork.denhamcapital.corp for database TEST MSG merovingian[17999]: starting database TEST due to control signal MSG TEST[18007]: executing '/usr/local/bin/mserver5' for database 'TEST' MSG merovingian[17999]: starting database 'TEST', up min/avg/max: 10/10/10, crash average: 0.00 0.00 0.00 (2-2=0) MSG TEST[18007]: # MonetDB server v5.8.0, based on kernel v1.26.0 MSG TEST[18007]: # Serving database 'TEST', using 8 threads MSG TEST[18007]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs statically linked MSG TEST[18007]: # Copyright (c) 1993-July 2008 CWI. MSG TEST[18007]: # Copyright (c) August 2008- MonetDB B.V., all rights reserved MSG TEST[18007]: # Visit http://monetdb.cwi.nl/ for further information MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:mdb: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:bat5: loader error /usr/local/lib/MonetDB5/lib/lib_bat5.so: undefined symbol: BATconvert MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:batExtensions: loader error lib_bat5.so.0: cannot open shared object file: No such file or dire ctory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:algebraExtensions: loader error lib_xml.so.0: cannot open shared object file: No such file or d irectory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:pqueue: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:factory: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:const: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:bbp: loader error lib_bat5.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:box: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:mat: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:bpm: loader error lib_bat5.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:inspect: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:manual: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:language: loader error lib_xml.so.0: cannot open shared object file: No such file or directory MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:constraints: loader error lib_xml.so.0: cannot open shared object file: No such file or directo ry MSG TEST[18007]: #WARNING: LoaderException:loadLibrary:mal_mapi: loader error /usr/local/lib/MonetDB5/lib/lib_mal_mapi.so: undefined symbol: ssl_rastr eam (and so on). I've tried both November and Novermber-SP1, with and without xquery, in misceleaneous and sundry combinations, and I wonder if it's a lib64 vesus lib issue, or whether mserver5/Mserver are failing to find some MAL files as well as thse so's. They have wound up in strange places like /usr/local/lib/MonetDB5/lib/lib_xml.so. What's the best way to tidy up this situation ? Denham Quantitative Management LP 200 Clarendon Street, 25th Floor Boston, MA 02216 T: 617-587-5812 M: 617-909-7786 omri.schwarz(a)denhamcapital.com NOTICE: This e-mail message is intended for the named recipient(s) above and may contain confidential information. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the message and any attachment(s) from your system. NO REPRESENTATION OR WARRANTY IS MADE TO ANY PERSON AS TO THE ACCURACY OR COMPLETENESS OF THE INFORMATION CONTAINED HEREIN. Denham Capital Management(sm) is a trademark of Denham Capital Management LP. [View Less]

2 1

[MonetDB-users] PF: "Group By" work-around no longer working?
by jz＠uva 14 Jan '09

14 Jan '09

Hi all, I am using MonetDB Nov2008-SP1 release with XQuery. I need to group the results that I retrieve by file. Since XQuery does not have a 'group by' function as in SQL, I was using the workaround of Borkar and Carey, see http://www.idealliance.org/proceedings/xml04/papers/229/XQueryExtensionsFin… This was working fine for the version of half year ago, but with the latest release the trick with 'distinct-values' is no longer working. The results are returned not grouped by file, e.g. {A,… [View More]

2 2

[MonetDB-users] Glusterfs db backend: MonetDB
by Mark V 13 Jan '09

13 Jan '09

Hi, It seems that glusterfs can be sensitive to the DB backend used in some cases. Has MonetDB been considered/contemplated as a back end? http://monetdb.cwi.nl/ http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html Given MonetDB is still being developed this would be more of a 'roadmap' item. Mark

1 0

[MonetDB-users] Optimizer exceptions when working with Mapi Interface
by David Svenson 08 Jan '09

08 Jan '09

Hi all, I am encountering strange exceptions that are related to the optimizer when working with the MAPI interface. I seem to be getting them when I use a few parallel threads to query the database (Always with the same query). However, I don't get them in a consistent way - I can't reproduce an exact scenario. The exception messages I get also vary - but they are always related to the optimizer. Here are a few of the exception messages I got: 'optimizer.rsColumn' undefined in: _50:any := … [View More]

2 3

[MonetDB-users] large COPY INTO jobs vs. INSERT
by David Svenson 08 Jan '09

08 Jan '09

Hi, I am working with MonetDB v 5.8.2 on a 32 bit machine with 2GB of RAM. I have a 20 CSV files, each containing 200,000 rows and 59 columns. I want to import all of them into one table. When I start running 'COPY INTO's to do that, everything goes well untill the 15th file (which should bring the table up from 2.8 million rows up to 3 million). The 15th file fails. When working with the MAPI interface, the database ends up being corrupt - but works again if I remove the logs. When trying … [View More]

1 0

[MonetDB-users] copy data from postgresql to monetdb?
by Chris Curvey 08 Jan '09

08 Jan '09

Hi! Newbie here! Before I go about trying to re-invent the wheel, has anyone written scripts to reverse-engineer a PostgreSQL database, convert the SQL to MonetDB's dialect and copy in the data? (I've Google and I can't seem to find such an animal.) -Chris -- Corruptissima republica plurimae leges

2 1

[MonetDB-users] Function errors
by David Svenson 08 Jan '09

08 Jan '09

Hi there... I've been trying to export the mtime. str_to_date function to the sql interface by calling the following script from the sql client: create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; After the function was created, I am trying to use it in the following way: select str_to_date('6 Dec 2001 12:33:45', '%d %b %Y %H:%M:%S'); But, I always get an error: "mtime.str_to_date:strptime support missing" Am I supposed to load some extra … [View More]

2 1

Re: [MonetDB-users] Hello. some questions about XRPC...
by Ying Zhang 07 Jan '09

07 Jan '09

Hello Nicolas, I need some more information about your problems to be able to help. First of all, some general questions: - which version of MonetDB/XQuery do you use? - which OS? - some hardware specifications On Jan 06, 2009, at 14:45 , Nicolas James wrote: > Hello Ying, > > Thanks for all these responses, they have been very helpful to me > (the real problem I had, and now resolved, was about the call to the > functions of pathfinder). > > I've coded a Java … [View More]client for indexing my data (image descriptions > and annotations in XML files) in MonetDB/XQuery, 46,557 XML > documents / 181.1Mo and I use XRPC. Is 181.1MB the size of one document (then the total size is > 8TB!) or the size of all 46557 documents? Do I understand it correctly that you have a Java client which send XRPC request messages to MonetDB/XQuery server to add documents? How does your Java client exactly work, i.e.: - does it add one document at a time, or all 46557 documents in one request? - is your Java client and MonetDB/XQuery server on the same machine? - do you use pf:add-doc() or fn:put() to add the documents? > My client works well but I don't understand some MonetDB behaviors. > My first tests created collections like my dataset and his > directories structure, I don't understand what you mean here. As far as I know, it is not possible to create nested collections in MonetDB/XQuery, and it is not possible to create empty collections (without adding a document). So, how did you create the collections? > but I've some directories with over that 900 documents, and I think > that MonetDB doesn't like that (i.e. 900 documents in one > collections), because the indexation failed. I don't know the exact max nr. of documents a collection may have, I think it is limited by if you are using a 32bits system or a 64bits system. Using mlcient, adding 46,557 documents of 11k each on a Fedora machine was no problem; adding > 900 documents of 200MB each is still processing (disk usage is still growing) when I'm writing this e-mail :) Did you add your documents using your Java client? Have you tried to add your documents without using XRPC, e.g., using mclient? What do you mean with "indexation failed"? Is there any error message? > Then, I try to split my dataset, I create collections of 128 > documents, but my problem is that in MonetDB all my collections does > not contain 128 doc, some 128 others a number between 5 and 128... > It's a little strange because I don't think the reason is my client... For this problem, I have similar questions, i.e.: - how large are the documents? - how are they added _exactly_? - Did you get any error message? Kind regards, Jennie > > Have you ever heard about a similar problem in MonetDB? > > Thanks previous responses, > > best regards, > > Nicolas James > > > Ying Zhang wrote: >> Hello Nicolas, >> >> First of all, thanks for trying MonetDB. I will try to answer your >> XRPC >> questions. >> >> >> On Tue, Dec 16, 2008 at 04:35:33PM +0100, Nicolas James wrote: >> >>> Hello MonetDB, >>> >>> I have some questions about the writing of a client for MonetDB in >>> Java using the XRPC, and It could be very very helpful for my >>> research if you could answer to some questions. >>> >>> I'm a PhD student in the MAS laboratory, Ecole Centrale Paris, >>> France, and I work on image automatic annotation. >>> I think MonetDB is extremely powerful and I want to use it in my >>> research, I would to store some images annotations under the form >>> of XML file in MonetDB since my application (a Java application). >>> >>> So, with your documentation I coded a light client using the JDBC >>> driver for adding my documents in MonetDB, but this way don't >>> satisfy me, the XRPC method is very attractive, but I've some >>> problems. >>> >>> 1) how add a document using the XRPCWrapper (using the pf:add-doc, >>> it's considered like an updating function, I've read the document, >>> but I don't understand...). >>> >> >> XRPC has several components. >> The XRPC protocol is a way of communicating with MonetDB/XQuery to >> run >> XQuery queries. An XRPC server is integrated in MonetDB/XQuery to >> handle requests speaking the XRPC protocol. >> >> Hence, to communicate with MonetDB/XQuery using XRPC, you only need >> to >> send requests according to the XRPC protocol. For Java, there are >> several API functions for creating request messages, sending and >> receiving messages, and handling response messages. The Java doc of >> these APIs could be found here: >> http://homepages.cwi.nl/~fabian/MonetDB/Java%20Package.html/index.html?nl/c… >> The Java package of the APIs could be found under the directory where >> you have installed MonetDB: share/MonetDB/lib/xrpcapi.jar >> In the same directory there is an xrpcclient.jar package, which gives >> an example of how to use the APIs. It's source could found in: >> java/src/nl/cwi/monetdb/xquery/xrpc/client >> >> You don't need the XRPCWrapper, in your case. XRPCWrapper is >> needed if >> you want to handle (simple) XRPC requests using another XQuery engine >> than MonetDB/XQuery. >> >> >> >>> 2) Is-it possible to create collections using the XRPC (and add >>> files in this collection) ? >>> >> >> I'm not sure if I understand you correctly. >> >> With XRPC, you can execute the pf:add-doc() function (you need to >> put it >> into an user-defined-function). with pf:add-doc(), you could specify >> the name of the collection to which you want to add your document. >> If >> such collection doesn't exist, it is created. Otherwise, your >> document >> will be added to the existing collection. >> >> >>> 3) and with the JDBC driver ? >>> 4) using the JDBC driver, is it possible to specify the reference >>> id for the file (for instance indexing the file "foobar.xml" and >>> referenced "foobar.xml" in the database ? >>> >> >> What do you mean with 'indexing the file "foobar.xml"'? >> (Disclaimer: I don't know much about the JDBC driver) >> >> >> Hope this helps a bit. If you have any problem with using the XRPC >> API, >> please don't hesitate to ask. >> >> >> >> Regards, >> >> Jennie >> >> >>> These answers could help me, hope you could have time to answer! >>> >>> best regards, >>> >>> -- >>> Nicolas James >>> PhD student MAS / ECP >>> Phone: +33.1.41.13.17.37 >>> Office: Lab, C 441A >>> Laboratoire MAS - Ecole Centrale Paris >>> Grande Voie des Vignes >>> 92295 CHATENAY MALABRY Cedex >>> France >>> >>> >> >> > > > -- > Nicolas James > PhD student MAS / ECP > Phone: +33.1.41.13.17.37 > Office: Lab, C 441A > Laboratoire MAS - Ecole Centrale Paris > Grande Voie des Vignes > 92295 CHATENAY MALABRY Cedex > France > [View Less]

1 0

[MonetDB-users] what is monet_vault_key used for?
by 小波顾 05 Jan '09

05 Jan '09

_________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

3 2

[MonetDB-users] Is there any way to run MonetDB as a Windows Service?
by 小波顾 05 Jan '09

05 Jan '09

Thanks. _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

3 2

[MonetDB-users] COPY INTO on aggregate queries crashes MonetDB
by Peter Farkash 04 Jan '09

04 Jan '09

Hi, When I use COPY INTO with a count query, monetDB crashes. For example: copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; Gives me the following result and kills the server: MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; ERROR = Connection terminated The same happens if I use sum, average, etc. On normal queries the copy into works just fine. I am using v5.8.2, and am getting the crash both … [View More]

2 1

[MonetDB-users] What code page does Monetdb currentlly use?
by 小波顾 03 Jan '09

03 Jan '09

We are Chinese users, and hoping Monetdb will support multi-byte character encodings like UTF-8 and GBK. _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

5 6

[MonetDB-users] Monetdb5 threading question.
by 小波顾 02 Jan '09

02 Jan '09

When I start the default demo database (or a new created one) process on Windows XP, the following messaged appears in the command window : # Serving databse 'demo', using 1 thread Does it mean the whole database process is single-threaded? The following section in the monetdb5.config file shows we can config multiple threads # Mserver 5 recognizes a series of command line names instead:# --threads ( 1 | PARMASK)# --memory (MEMMASK )# --properties (CHECKMASK | PROPMASK | BATMASK )# --io (… [View More]

3 4

[MonetDB-users] Multiple database question.
by 小波顾 02 Jan '09

02 Jan '09

I have created a customed version of the MServer5.bat and MClient.bat to serve multiple databases. MServer5.bat : set MONETHOME=D:\Amber\Program\MonetDB\MonetDB5 set MONETDATAROOT=%1set MONETDATAROOT=%MONETDATAROOT:~0,-1%set MONETDBNAME=%2 if "%MONETDATAROOT%" == "" pauseif "%MONETDBNAME%" == "" pause set PATH=%MONETHOME%\bin;%MONETHOME%\lib;%MONETDB%\lib\MonetDB5;%PATH% set MONETDBFARM=--dbfarm="%MONETDATAROOT%\dbfarm"set SQLLOGDIR=--set "sql_logdir=%MONETDATAROOT%\sql_logs"set … [View More]

2 2