[MonetDB-users] a couple of questions
(I might have send this first to the wrong email address. Here's a repetition.) Hi team, I have a couple of small questions and remarks: * mclient timer doesn't work when running mclient with -s option. [lafanasi@zookst4 stats]$ mclient -t -lx -s "count(doc('xmark01.xml'))" 1 [lafanasi@zookst4 stats]$ mclient -lx -t q1.xq 1 Timer 5.606 msec * does mclient option -I (capital i) work? For example, the following command doesn't execute in 1 min. [lafanasi@zookst4 stats]$ mclient -lx -I xmark01.xml -s "count(.)" * Recently I couldn't access my db created with the latest release after recompilation from HEAD. Do I need to back-up my db (by dumping the tables) when I recompile a new version from HEAD? A new release? * Mserver crushes on XMark of 11GB (-f 100). The query is: "find the maximum length of the root to leaf paths, i.e., the tree depth". My specs: Linux zookst4 2.6.24.3-50.fc8 #1 SMP Thu Mar 20 13:39:08 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux, Mem 19GB. Do you have any tips on how to make it run? Thanks for your help! l.
On Thu, Nov 20, 2008 at 12:08:16PM +0100, Loredana Afanasiev wrote:
(I might have send this first to the wrong email address. Here's a repetition.)
Hi team,
I have a couple of small questions and remarks:
* mclient timer doesn't work when running mclient with -s option.
[lafanasi@zookst4 stats]$ mclient -t -lx -s "count(doc('xmark01.xml'))" 1 [lafanasi@zookst4 stats]$ mclient -lx -t q1.xq 1 Timer 5.606 msec
Confirmed. Could you please file a bug report about this?
* does mclient option -I (capital i) work? For example, the following command doesn't execute in 1 min. [lafanasi@zookst4 stats]$ mclient -lx -I xmark01.xml -s "count(.)"
`mclient --help` says ======== XQuery specific options -C colname | --collection=colname collection name -I docname | --input=docname document name, XML document on standard input ======== i.e., you mclient waits for the document to appear on standard input ;-) You probably mean to do something like cat xmark01.xml | mclient -lx -I xmark01.xml -s "count(.)" or mclient -lx -I xmark01.xml -s "count(.)" < xmark01.xml In fact, I don't know whether -I works in combination with -s; hence, the alternative is mclient -lx -I xmark01.xml < xmark01.xml mclient -lx -s 'count(doc("xmark01.xml"))'
* Recently I couldn't access my db created with the latest release after recompilation from HEAD. Do I need to back-up my db (by dumping the tables) when I recompile a new version from HEAD? A new release?
WhicH version was your DB created with? The last stable release (Jun2008 or Aug2008)? If so, you indeed have to dump your DB *with that version* *before* upgrading to the HEAD (or better the "soon" to be announce new Stable "Nov2008" release), and the reload the dump after upgrading. Like between the Feb2008 and Jun2008 releases (cf., http://monetdb.cwi.nl/Development/Releases/Version4.24/), we again had to change the physical database format since the Jun2008 release --- development for improvements never stops ;-)
* Mserver crushes on XMark of 11GB (-f 100). The query is: "find the maximum length of the root to leaf paths, i.e., the tree depth". My specs: Linux zookst4 2.6.24.3-50.fc8 #1 SMP Thu Mar 20 13:39:08 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux, Mem 19GB. Do you have any tips on how to make it run?
How does it crash? Any error messages? How big does Mserver grow before crashing? What exactly does you query look like in XQuery? How did you configure & compile MonetDB? Which version of MonetDB do you use? Did you try both the algebra and the milprint_summer back-end / Pathfinder compiler? Stefan
Thanks for your help! l.
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
participants (2)
-
Loredana Afanasiev
-
Stefan Manegold