New subject: [MonetDB-users] MonetDB-users Digest, Vol 50, Issue 11

28 Jul 2010


      Hi Niels:

I don't care if the log gets written on table creation. I tried the flag
 but it didn't do anything. The default value is 0. In the FebPS2 version
it's a debug flag - actually setting it to 128 doesn't help. On closer
examination it appears that it checks for if (debug & 1) then it would write
a log. Setting debug to 128, would imply that debug & 1 = 0 and so no debug
output is written. Can you tell me where the log writer code is ? Is it
gdk_logger.c ? if yes, which is the function that writes the
log_write_format, log_write_string, if not which ones.
  -- Shailendra

------------------------------
...
Message: 5
Date: Wed, 28 Jul 2010 08:40:06 +0200
From: Niels Nes 
Subject: Re: [MonetDB-users] Creating table with nologging.
To: Communication channel for MonetDB users
       
Message-ID: <20100728064006.GA6626@cwi.nl>
Content-Type: text/plain; charset=utf-8
On Tue, Jul 27, 2010 at 04:28:56PM -0700, Shailendra Mishra wrote:
...
I have the need for creating table with nologging enabled. I do
understand that MonetDB is not meant to be used this way. However, I am
trying to use it to ingest data off data-feeds. My db lives on a SSD,
and the only DML that I execute is INSERT. I would appreciate if folks
familiar with the server code could point me source files ?where I
could make the change to achieve this. Thanks in advance for your help.
-- Shailendra
Shailendra
I haven't tried this in a while but it used to be possible to switch
logging of inserts of using a debug flag (passed to the logger code).
See the file src/storage/bat/bat_logger.mx
function bl_create. The first argument to logger_create should
be 128 to switch off logging.
This will only disable that every insert will also write the inserted
values to the log. It still creates a log for your initial create table
statement.
Indeed this is un documented and far from normal supported usage of
monetdb.
Niels

Re: [MonetDB-users] MonetDB-users Digest, Vol 50, Issue 11

Shailendra Mishra

Niels Nes

Shailendra Mishra

tags

participants (2)