Hi Bart, It is the physical database size as the NumberOfBuffers is a memory param and the database size is the size on disk, where the checkpoint it committing the data to ...
Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers On 1 Apr 2014, at 15:47, Bart Vandewoestyne <bart.vandewoest...@telenet.be> wrote: > Hello list, > > The virtuoso.ini file has a MaxCheckpointRemap parameter for both the > [Database] and the [TempDatabase] section. > > Concerning this parameter, the documentation says: > > "Also, if running with a large database, setting MaxCheckpointRemap to > 1/4th of the database size is recommended. This > is in pages, 8K per page." > > I was wondering whether I am correctly calculating my value for > MaxCheckpointRemap. My reasoning is as follows: > > I have the following file sizes for the databases (is 'file size of the > .db files' what is meant by 'database size' by the way?) > > -rw-r--r-- 1 bart bart 115343360 Apr 1 16:28 virtuoso-temp.db > -rw-r--r-- 1 bart 1007 152135794688 Apr 1 16:21 virtuoso.db > > So using 8K per page, i calculate: > > For virtuoso.db: > (152135794688 * 0.25) / 8000 = 4754243 > > For virtuoso-temp.db: > (115343360 * 0.25) / 8000 = 3604 > > So I have > > [Database] > ... > MaxCheckpointRemap = 4754243 > ... > > [TempDatabase] > ... > MaxCheckpointRemap = 3604 > ... > > Is this the correct way of setting a value for MaxCheckpointRemap ? > > I'm asking this, because I've also seen websites where people simply set > the value of MaxCheckpointRemap to be 1/4 of NumberOfBuffers... > > Kind regards, > Bart > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
