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 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
On Wed, Jul 28, 2010 at 02:56:58PM -0700, Shailendra Mishra wrote:
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.
Indeed gdk_logger.mx is the file too look at. The log_bat function has code to disable logging, ie
if (lg->debug & 128) { /* logging is switched off */ return LOG_OK; }
Niels
-- 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
The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Niels:
Sorry, I made a mistake, the suggestion worked. I changed the .mx file instead of the .c file - I only have super tar ball, so changing the .mx file would have no effect. Thanks a ton for your help. - Shailendra
On Wed, Jul 28, 2010 at 2:56 PM, Shailendra Mishra shailendrah@gmail.comwrote:
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 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
participants (2)
-
Niels Nes
-
Shailendra Mishra