Changes between Version 15 and Version 16 of DbPurge


Ignore:
Timestamp:
Dec 23, 2014, 4:40:41 PM (10 years ago)
Author:
davea
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DbPurge

    v15 v16  
    11= Database purging utility =
    22
    3 As a BOINC project operates, the size of its workunit and result tables increases.
    4 Eventually they become so large that adding a field or building an index may take hours or days.
    5 To keep this from happening, BOINC provides a utility '''db_purge'''
     3As a BOINC project operates, the size of its workunit and result tables increase.
     4To limit this growth, BOINC provides a utility '''db_purge'''
    65that writes result and WU records to XML-format archive files,
    76then deletes them from the database.
     
    1514It has the following command-line options:
    1615
    17  '''-min_age_days X '''::
    18         Purge only WUs with mod_time at least X (can be < 1) days in the past.
     16 '''--app appname'''::
     17   Purge only workunits of the given app.
     18 '''-d N'''::
     19   Set logging verbosity to N (1,2,3,4)
     20 '''--daily_dir'''::
     21   Write archives in a new directory (YYYY_MM_DD) each day
     22 '''--dont_delete'''::
     23   Don't delete from DB, for testing only
     24 '''--gzip'''::
     25   Compress archive files using gzip
     26 '''--max N'''::
     27   Purge at most N WUs, then exit
     28 '''--max_wu_per_file N'''::
     29   Write at most N WUs to each archive file. Recommended value: 10,000 or so.
     30 '''--min_age_days X '''::
     31  Purge only WUs with mod_time at least X (can be < 1) days in the past.
    1932  Recommended value: 7 or so.
    2033  This lets users examine their recent results.
    21  '''--max N'''::
    22         Purge at most N WUs, then exit
    23  '''--max_wu_per_file N'''::
    24         Write at most N WUs to each archive file. Recommended value: 10,000 or so.
    2534 '''--mod N R'''::
    26         Process only WUs with ID mod N == R.  This lets you run multiple instances for increased throughput.  Must be used with --no_archive.
     35   Process only WUs with ID mod N == R.  This lets you run multiple instances for increased throughput.  Must be used with --no_archive.
     36 '''--no_archive'''::
     37   Don't archive workunits or results
     38 '''--one_pass'''::
     39   Do one pass, then quit
    2740 '''--zip'''::
    28         Compress archive files using zip
    29  '''--gzip'''::
    30         Compress archive files using gzip
    31  '''--daily_dir'''::
    32         Write archives in a new directory (YYYY_MM_DD) each day
    33  '''-d N'''::
    34         Set logging verbosity to N (1,2,3)
    35  '''--no_archive'''::
    36         Don't archive workunits or results
    37  '''--dont_delete'''::
    38         Don't delete from DB, for testing only
    39  '''--one_pass'''::
    40         Do one pass, then quit
     41   Compress archive files using zip
    4142
    4243== Recording credited jobs ==
     
    204205}}}
    205206
    206 
    207 
    208 
    209