- users-list - monetdb.org

Re: [MonetDB-users] [Monetdb-developers] the database and index size
by Stefan de Konink 01 Apr '10

01 Apr '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Op 01-04-10 17:33, Mo Zhou schreef: > Does monetdb compress data in the database? I load plain text file > (12M) into a database with only one table. I shut down the database > right after that and check the size of the database. The database size > is only 8M. Obviously the amount of storage required for storing integers larger than 4 digits in plain text is higher than the amount of data that is required to represent a 4byte integer. Regarding to strings best effort deduplication is choosen. Like with any fileformat there is some metadata overhead. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAku0xBsACgkQYH1+F2Rqwn2vWwCdFts9Z8wYtLEsrqslimq/I3Vi OWEAnjIArIUtzI8yf4mhdlHF/Fy1pS5x =aXYs -----END PGP SIGNATURE-----

1 0

[MonetDB-users] ubuntu server installation / php modules
by dariuszs 29 Mar '10

29 Mar '10

Hi, I've installed monetdb on *Ubuntu 9.04 Server* with apt-get. These are the contents of php client /. /usr /usr/share /usr/share/doc /usr/share/doc/php5-monetdb-client /usr/share/doc/php5-monetdb-client/changelog.Debian.gz /usr/share/doc/php5-monetdb-client/copyright I need the moduels, where are they? Thanks. Dariusz.

2 3

[MonetDB-users] can't log in to my own databases...
by Robert Dormer 28 Mar '10

28 Mar '10

Hello all, I've installed monetdb from the Feb 2010 source release on a Gentoo 10.1 box. I've created a database (finance), and have released it from administration mode, but every time I try to access it with mclient, I get a prompt for a user name and password, followed by an InvalidCredentialsException:checkCredentials error. When I created the database it didn't ask for any user name or password. How do I get in to my own database?

2 1

[MonetDB-users] doco on syntax for SQL create function?
by Michael Pheasant 27 Mar '10

27 Mar '10

Hi I'm trying to create an SQL function but struggling with thi syntax for the body of the function. Is there other more detailed doco than this page? http://monetdb.cwi.nl/SQL/Documentation/Functions.html#Functions Cheers Mike

2 1

[MonetDB-users] PHP Benchmarks of Native versus Cimpl?
by Steve Benz 25 Mar '10

25 Mar '10

Hi~ I've recently converted our monet install from the cimpl version of the php interface to the new native socket interface. I see the readme references some benchmarks at a url that does not appear to exist (http://www.ins.cwi.nl/~gm/bench/) Would someone be able to please point me to a version of these? Thanks so much! Steve

5 7

[MonetDB-users] Virtual Memory Requirement
by Hering Cheng 25 Mar '10

25 Mar '10

Hi, I am trying to understand the limitations of MonetDB with regard to memory. It seems that the amount of virtual memory (RAM plus swap space) available to MonetDB must be greater than the amount of data. Before I give up on MonetDB, can someone please confirm or correct my understanding? I did not understand the virtual memory requirement when I read the following in its documentation ( http://monetdb.cwi.nl/MonetDB/Documentation/Size-Limitations.html#Size-Limi… ): *The maximal database size supported by MonetBD depends on the underlying processing platform, e.g., a 32- or 64-bit processor, and storage device, e.g., the file system and disk raids. * For example, I started up merovingian (using the Feb 2010 release), limiting it and its child processes to 32 GB of virtual memory (via ulimit -v). I then try to load 115 GB of data into a single table. mclient reports the following: MAPI = chenher@myserver50000 COPY 472112651 RECORDS INTO mytable FROM 'mydata.txt' DELIMITERS '|', '\n'; ERROR = !SQLException:importTable:failed to import table !ERROR: HEAPextend: failed to extend to 1888450604 for 17/1734tail !ERROR: TABLETcreate_bats: Failed to create bat of size 472112651 I understand if MonetDB must be able to fit all its data within virtual memory. But if this is the case, then unfortunately I cannot use it, since I have terabytes of data and I do not have that much virtual memory on my hardware. Thank you. Hering

4 8

[MonetDB-users] How to run monetdb and create a database, with the geom module?
by Michael Pheasant 25 Mar '10

25 Mar '10

I cannot figure out how to do geom stuff with the Fedora 12 rpm binary install. If I run $ sudo mserver5 --dbinit="include geom; include sql;sql.start();" then in another shell try and create a test database i get an error than monetdb (merovingian) is not running: $ sudo monetdb create test monetdb: cannot perform: MonetDB Database Server (merovingian) is not running If I run merovingian, then it starts the MonetDB with --dbinit="include sql" I can then create a database, but I cant load the GEOM extensions. So I feel like I end up in a catch-22. Can someone explain how I can run monetdb, and create a database, with the geom module? Cheers Mike.

2 1

[MonetDB-users] Load a file.txt in bats
by Miguel Ángel Águila Lorente 24 Mar '10

24 Mar '10

Hello, I'm creating a database with MAL. I would need help for creating bats with the information of a file. May be It could be posible to do with tablet.load but I still not know how it works. The format of the file is quite simple: int;int;int; int;int;int; I expect you can help me. Thank you. Mike

2 3

[MonetDB-users] Java executeBatch() behavior
by sateesh 23 Mar '10

23 Mar '10

Hi All, When we try to execute a Set of SQL Statements using executeBatch() and if one of the SQL Query fails then MonetDB seems to be ignoring the rest. Is there a way we can configure MonetDB to execute the remaining SQL Queries in the Batch ?? Thanks Sateesh -- View this message in context: http://old.nabble.com/Java-executeBatch%28%29-behavior-tp27783879p27783879.… Sent from the monetdb-users mailing list archive at Nabble.com.

2 6

[MonetDB-users] Transaction Management
by אייל 22 Mar '10

22 Mar '10

hi, this is from the documentation of Transaction Management: "If at commit time it can be assured that the data prepared for update affects tables not changed in the mean time, the results are merged." dose it mean that two users cannot change DIFFERENT records of the same table at the same time? what isolation levels dose MonetDB supports? thanks.

1 0