Changes between Version 4 and Version 5 of DbPurge


Ignore:
Timestamp:
Sep 18, 2009, 4:08:48 PM (15 years ago)
Author:
davea
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DbPurge

    v4 v5  
    11= Database purging utility =
    22
    3 As a BOINC project operates, the size of its workunit and result tables increases. Eventually they become so large that adding a field or building an index may take hours or days.
    4 To address this problem, BOINC provides a utility '''db_purge''' that writes result and WU records to XML-format archive files, then deletes them from the database.
    5 Workunits are purged only when their input files have been deleted. Because of BOINC's file-deletion policy, this implies that all results are completed. So when a workunit is purged, all its results are purged too.
     3As a BOINC project operates, the size of its workunit and result tables increases.
     4Eventually they become so large that adding a field or building an index may take hours or days.
     5To keep this from happening, BOINC provides a utility '''db_purge'''
     6that writes result and WU records to XML-format archive files,
     7then deletes them from the database.
     8Workunits are purged only when their input files have been deleted.
     9Because of BOINC's file-deletion policy, this implies that all results are completed.
     10So when a workunit is purged, all its results are purged too.
    611
    712db_purge creates an archive/ directory and stores archive files there.
    813
    9 db_purge is normally run as a daemon, specified in the [ProjectConfigFile config.xml] file. It has the following command-line options:
     14db_purge is normally run as a daemon, specified in the [ProjectConfigFile config.xml] file.
     15It has the following command-line options:
    1016
    1117 '''-min_age_days N '''::