April 2009 - users-list

[MonetDB-users] timer option in monetdb
by Mayank Maheshwari 14 Apr '09

14 Apr '09

Hi, I'm working on a project comparing the performance of column-store database systems using MonetDB with the common row-stores for different query scenarios. While running the --timer option on monetDB, I was wondering if it includes the time for printing the result and any other I/O time as well. I'm trying to get the break-up of where the system spends its time while processing the query. Is there a way I could find that out? Also is it possible to find out whats the compression scheme the database is using to store the data? I'm storing a 1 million row table with 6 attributes. Thanks. Mayank Maheshwari mayank(a)cs.wisc.edu

1 0

[MonetDB-users] Fast Loading
by Alex Bo. 14 Apr '09

14 Apr '09

Hi, I came across chapter 3.2.8 in the documentation regarding 'Fast Loading'. I am trying to use it in order to improve the performance I get compared to loading tables using 'COPY INTO'. However, I am not sure how to approach this: "Each file is produced by a program that writes the binary image of the BAT directly, i.e. a binary dump of an C-array" How exactly can I produce these binary images from my source columns? How exactly are they expected by MonetDB to look like? A little more info could be very helpful. Thanks. -- View this message in context: http://www.nabble.com/Fast-Loading-tp23009932p23009932.html Sent from the monetdb-users mailing list archive at Nabble.com.

5 4

[MonetDB-users] mysql vs. monetdb
by Yue Sheng 08 Apr '09

08 Apr '09

Hi, we installed MonetDB on a Linux box, and did some comparison between MySQL and MonetDB. The result seems off by a large magnitude. Has anyone encountered similar problem please? Thanks. For MonetDB: ql>select count(ins_key) from bigtable where ins_key = 15012; +---------+ | L1 | +=========+ | 1931541 | +---------+ 1 tuple Timer 260771.478 msec 1 rows For MySQL: select count(ins_key) from bigtable where ins_key=15012; +----------------+ | count(ins_key) | +----------------+ | 1931548 | +----------------+ real 0m0.989s user 0m0.002s sys 0m0.003s Indices: MonetDB: None MySQL: index on ins_key Thanks.

3 4

[MonetDB-users] Admin GUI not working on Vista 64
by Max Fedorov 08 Apr '09

08 Apr '09

Installed 64 bit version of MoneyDB on Vista. Server and client are working fine, but Admin GUI is coming up with 404. Thanks. -Max

2 4

[MonetDB-users] MonetDB Server logs and location on Windows
by Max Fedorov 07 Apr '09

07 Apr '09

Hello. I have MonetDB installed on Windows XP. The server crashed several times for me during shredding of several files (1mill records each). I am running this Window XP instance in VM, so maybe disk space or memory was an issue. 1. Where are the logs? 2. Also, what is the physical location of the database itself? 3. What is the best strategy to prevent data loss if server crashes. Do I need to backup files or backup through Admin GUI? Thanks a lot!

2 1

[MonetDB-users] XQuery Suggestions
by Max Fedorov 07 Apr '09

07 Apr '09

Hello, please advise why these 2 queries do not work. Samples would be nice. module namespace foo = "xrpc-test-function"; declare function foo:countQueueStats($docName as xs:string) as xs:integer { count(doc($docName)/qflex:queueStats/qflex:queueStat/qflex:queueName) }; declare function foo:addQueueStat($docName as xs:string, $myElement as element()) { do insert $myElement as last into doc($docName)/queueStats }; Thank you!

4 7

[MonetDB-users] Mserver error
by Stefan Klinger 02 Apr '09

02 Apr '09

Hi. I just updated to the 'current' branch via the provided 'monetdb-install.sh'. Now I get an error message when starting Mserver: >>>>> sk@phobos18:~> Mserver # MonetDB Server v4.29.0 # based on GDK v1.29.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: CMDfind: value not found. !ERROR: CMDfind: operation failed. !ERROR: interpret_params: int(param 1): evaluation error. MonetDB> <<<<< Even worse, I cannot use Pathfinder any more: >>>>> sk@phobos18:~> Mserver --dbinit='module(pathfinder);mil_start();' # MonetDB Server v4.29.0 # based on GDK v1.29.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: CMDfind: value not found. !ERROR: CMDfind: operation failed. !ERROR: interpret_params: int(param 1): evaluation error. # PF/Tijah module v0.9.0 loaded. http://dbappl.cs.utwente.nl/pftijah !ERROR: interpret: unknown variable 'REMAP_PAGE_SIZE'. !ERROR: interpret_params: BAT(param 3): evaluation error. !ERROR: interpret_params: rename(param 1): evaluation error. MonetDB> <<<<< Any help wouldbe appreciated. Kind regards, Stefan -- Stefan Klinger o/klettern /\/ bis zum send plaintext only - max size 32kB - no spam \ Abfallen http://stefan-klinger.de

2 1