Hi, 64-bit Windows (and a 64-bit MonetDB, I assume?) with 48 GB of memory does not sound too bad --- well, it depends on how large your tables are --- 100 millions rows long ans 300 fields wide, but how wide are the fields, i.e., what type are they? I you successfully manages to load all the data, I see no obvious reasons why simple `select count(*) from table;` queries should not work as well ... Could please be a bit more elaborate with discribing your problem? Could you please recap in detail all the steps since installing MonetDB that eventually led to the current problems? In particular, we'd need to know of any errors or other message that the server and/or client showed and of any cases where you killed either server or client in any way. Do I understand you correctly, that you now manage to start the MonetDB/SQL server without problems getting a server console, and that then starting the MonetDB/SQL client (both started the default way, i.e., via the respective entries in the start menu?) yields no a window with a blinking prompt? Can you type on that prompt? If so, can you run a trivial query such as `select 1;`? Do you get an answer for that? We'd at least need to know all this to get a vague idea what might be wrong --- better still, it would be great if you could give as a clear recipe how we could try to reproduce your problem ... Stefan On Tue, Jan 27, 2009 at 04:25:30PM -0500, dariuszs wrote:
Hi, Maybe I need a bigger box for what I'm doing. Right now it's 64 bit windows machine with lots of SAS storage and 48GB of memory. I've setup few tables with over 100 million records and about 300 fields in each table, and I'm running counts on those tables at the same time. Could you advise. Thanks. Dariusz.
Stefan Manegold wrote:
On Tue, Jan 27, 2009 at 03:50:02PM -0500, dariuszs wrote:
Hi, Can somebody help me with this one. I was running a very long query, decided to terminate that job. Now when I try to get the client all I see is blinking prompt. How do I get back the sql prompt? Thanks. Dariusz.
- did you terminate only the client or also the server? - is your server still running? if not, you need to restart it. if it is, is it idle or busy? in any case quitting the server and restarting it might be a good idea. note though, that starting the server might take some time, in case it need to reply the write-ahead logs.
(do I recall correctly, that you are using the Nov2008 version of MonetDB (or Nov2008-SP1 or Nov2008-SP2?) on Win32?
Stefan
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ 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 |