Sjoerd Mullender wrote:
> Why do you want to be able to flush all changed files to disk? MonetDB
Hint, we see very bad behavior in the second query, while it is identical
to the first. One idea is to 'somehow' kick the system into a state as
it was started. The assumption was that dirty pages may be polluting the memory,
so a forceful sync could do that.
"
According to the standard specification (e.g., POSIX.1-2001), sync()
schedules the writes, but may return before the actual writing is done.
However, since version 1.3.20 Linux does actually wait. (This still
does not guarantee data integrity: modern disks have large caches.) "
I was betting on the last remark
> already does flushes when they are needed for transaction support. I
> don't think we need to tell the kernel to synchronize any other files
> with the disk. This function doesn't do anything with memory management
> within the process.
>
> Furthermore, this function is not available on Windows.
was to experiment with the blkjoin issues, it can be dropped again.
>
> Martin Kersten wrote:
>> Update of /cvsroot/monetdb/MonetDB5/src/modules/kernel
>> In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv20459
>>
>> Modified Files:
>> unix.mx
>> Log Message:
>> We want to experiment with complete flushing memory in out of memory
>> queries.
>>
>>
>> U unix.mx
>> Index: unix.mx
>> ===================================================================
>> RCS file: /cvsroot/monetdb/MonetDB5/src/modules/kernel/unix.mx,v
>> retrieving revision 1.24
>> retrieving revision 1.25
>> diff -u -d -r1.24 -r1.25
>> --- unix.mx 7 Jan 2009 14:15:12 -0000 1.24
>> +++ unix.mx 27 Jul 2009 06:29:44 -0000 1.25
>> @@ -35,6 +35,10 @@
>> address UNIXsetenv
>> comment "Set the environment variable string.";
>>
>> +command sync() :void
>> +address UNIXsync
>> +comment "Flush memory, expensive but sometimes needed";
>> +
>> @- Implementation
>> The remainder is a straight forward mapping to the underlying
>> facilities
>> @@ -113,4 +117,10 @@
>> return MAL_SUCCEED;
>> }
>>
>> +unix_export str UNIXsync(int *res);
>> +str UNIXsync(int *res){
>> + (void) res;
>> + sync();
>> + return MAL_SUCCEED;
>> +}
>> @}
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> Monetdb-checkins mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/monetdb-checkins
>
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Monetdb-checkins mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/monetdb-checkins
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
