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

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