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
