Is there any method, besides restarting the database,
of shrinking the sql log file?
When I am performing a large set of large inserts (via
COPY INTO) the log file gets very large. I wish there
was a way to cycle the log file.
Also during these large batches of inserts the
database server becomes less and less responsive until
I am forced to restart the server. Upon restart and
the normal recovery monet returns to a very responsive state.
Hi all: I'm trying to measure the response time of MonetDB against a
commercial RDBMS, so I've made a dump of the data from my current database
in order to load into MonetDB. I have approximately 2.6 million rows,
divided into 26 flat files of 100k rows each one, which I load using then
SQL command "copy into....". Everything works ok with the data load
(performing a commit after each 100k file), and I can make use of that data
in the same session from which I've loaded the data, but when I restart
MonetDB Server, I can't login via SQL (I can start MonetDB Server, but SQL
Client doesn't respond).
Apparently, from what I can realize, after the shutdown of MonetDB Server,
there is a big log file in Monet's sql_logs directory, and when I get a
response from SQL Client, the log file is apparently empty (I've realized
this loading only 200k rows).
Is this the expected behaviour for the MonetDB SQL Server? Did I miss
anything in order to avoid this? After the second start of the server, this
doesn't happen anymore until I load new data.
I'm working with MonetDB Server v5.0.0_beta1_2 (downloaded msi from
sourceforge) over Windows XP, and the SQL Client is via JDBC.
Thanks in advance for any help you can give me.
Franco
--
View this message in context: http://www.nabble.com/Not-responding-after-sql-server-restart-tf3762198.htm…
Sent from the monetdb-users mailing list archive at Nabble.com.
Hi,
I am trying to test the backup/restore of a MonetDB database. I
installed MonetDB latest version on a 32Bit Red hat Linux. I created a
database on Machine-1, created a table and loaded the table with 1M
rows. After that I shutdown the database and took a back-up of the
entire "dbfarm" directory. I moved the backup to Machine-2 where the
"dbfarm" directory points to the similar location as Machine-1. I then
opened the database on Machine-2 but there is no table/data on
Machine2 even though the directory contents between the 2 machines
appear the same. Please let me know if I am missing something.
I also made sure that Machine-2 is not creating the database in any
other location, except the location where I copied all the files.
The idea here is to create the database on one machine and then move
the database to different machine using simple file system COPY.
Thanks,
- Venks
Hi, I'm trying to using connection pooling in MonetDB (version 5) via Apache
Commons-dbcp, but there is some error during the connectrion to MonetDB,
message that I get from log file is as the following :
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool exhausted
......
Caused by: java.util.NoSuchElementException: Could not create a validated
object, cause: writable mode not supported
... 64 more
Can anyone show me the correct way to implement connection pooling with
MonetDB ? Or it is not supported in the current release of MonetDB ?
Beside, I also found that the aliased columns not recognized after "group
by... order by", my SQL statement could as the following...
SELECT name AS n FROM students ORDER BY name;
And the error message I get was ORDER BY: no such column "name".
Im very new to MonetDB, and wants to used it with Modrian OLAP for reporting
purposes, I really appreciate any help in this. Thanks
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 5/22/2007
3:49 PM
Hello everyone,
We are evaluating Monet right now to store and analyze a huge quantity of data.
We have several facts collection that range from 1 million row, 200 cols. to
way over 300 million rows and over 10.000 columns.
We are aware of memory limitations of current Monet version and looking forward
to the new one but in the meantime we'd like to do some performance and load
tests.
In order to know which data we will be able to store, we need to know how much
memory will use a BAT depending on the datatype and the number of elements we
want to store in it.
Is there a lineal relation between those variables (ie. 8 bytes oid, 8 bytes
int => 16 bytes per element) or do Monet encode data using intervals or such?
Thank you in advance and kudos for your big efforts,
Guillermo Arbeiza,
Open Sistemas de Información e Internet
garbeiza(AT)opensistemas.com
----------------------------------------------------------------------
Mensaje enviado por el servidor de openSistemas (www.opensistemas.com)
Good day.
Your family member has sent you an ecard from duhymn.hk.
Send free ecards from duhymn.hk with your choice of colors, words and music.
Your ecard will be available with us for the next 30 days. If you wish to keep
the ecard longer, you may save it on your computer or take a print.
To view your ecard, choose from any of the following options:
--------
OPTION 1
--------
Click on the following Internet address or
copy & paste it into your browser's address box.
http://duhymn.hk/?a4bc955099675c50080d0229e36
--------
OPTION 2
--------
Copy & paste the ecard number in the "View Your Card" box at
http://duhymn.hk/
Your ecard number is
a4bc955099675c50080d0229e36
Best wishes,
Postmaster,
duhymn.hk
*If you would like to send someone an ecard, you can do so at
http://duhymn.hk/
Are muffled into silence that refusesIn search of brighter green to come. No way!Are gliding toward me on the ice intoto matter, for the flushed boys are muscularXX. To the PoleLike an old soldier, wakeful, in his tent!Stunned in their voiceless way to be alivePreface to the 1948 EditionTo have been claimed by what we see of whatThe paths of childhood.Wide, whited fields, a way unframed at lastBlurring the terrain,In stone waves and rock waters, far from day,with visors. Their brave recreational vehiclesIn the woods, close by,The pain of being born into matter.Whiteness, those pediments that riseDown the long course of the gray slush of thingsA frame of glided twilight—I
The only way I've been able to combine separate date
and time columns into a single timestamp is with a set
of cast functions.
e.g.
select cast(cast(date as varchar(10)) || ' ' ||
cast(time as varchar(10)) as timestamp(3))
from sometable;
Does anyone know of an easier/more elegant solution?