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 <Niels.Nes@cwi.nl>
Subject: Re: [MonetDB-users] Creating table with nologging.
To: Communication channel for MonetDB users
<monetdb-users@lists.sourceforge.net>
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