Changes between Version 15 and Version 16 of DbPurge

Timestamp:

Dec 23, 2014, 4:40:41 PM (9 years ago)

Author:

davea

Comment:

--

DbPurge

@@ -1 +1 @@
 = Database purging utility =
 
-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.
-To keep this from happening, BOINC provides a utility '''db_purge'''
+As a BOINC project operates, the size of its workunit and result tables increase.
+To limit this growth, BOINC provides a utility '''db_purge'''
 that writes result and WU records to XML-format archive files,
 then deletes them from the database.
@@ -15 +14 @@
 It has the following command-line options: 
 
- '''-min_age_days X '''::
-        Purge only WUs with mod_time at least X (can be < 1) days in the past.
+ '''--app appname'''::
+   Purge only workunits of the given app.
+ '''-d N'''::
+   Set logging verbosity to N (1,2,3,4)
+ '''--daily_dir'''::
+   Write archives in a new directory (YYYY_MM_DD) each day
+ '''--dont_delete'''::
+   Don't delete from DB, for testing only
+ '''--gzip'''::
+   Compress archive files using gzip
+ '''--max N'''::
+   Purge at most N WUs, then exit
+ '''--max_wu_per_file N'''::
+   Write at most N WUs to each archive file. Recommended value: 10,000 or so.
+ '''--min_age_days X '''::
+  Purge only WUs with mod_time at least X (can be < 1) days in the past.
   Recommended value: 7 or so.
   This lets users examine their recent results.
- '''--max N'''::
-        Purge at most N WUs, then exit
- '''--max_wu_per_file N'''::
-        Write at most N WUs to each archive file. Recommended value: 10,000 or so.
  '''--mod N R'''::
-        Process only WUs with ID mod N == R.  This lets you run multiple instances for increased throughput.  Must be used with --no_archive.
+   Process only WUs with ID mod N == R.  This lets you run multiple instances for increased throughput.  Must be used with --no_archive.
+ '''--no_archive'''::
+   Don't archive workunits or results
+ '''--one_pass'''::
+   Do one pass, then quit
  '''--zip'''::
-        Compress archive files using zip
- '''--gzip'''::
-        Compress archive files using gzip
- '''--daily_dir'''::
-        Write archives in a new directory (YYYY_MM_DD) each day
- '''-d N'''::
-        Set logging verbosity to N (1,2,3)
- '''--no_archive'''::
-        Don't archive workunits or results
- '''--dont_delete'''::
-        Don't delete from DB, for testing only
- '''--one_pass'''::
-        Do one pass, then quit
+   Compress archive files using zip
 
 == Recording credited jobs ==
@@ -204 +205 @@
 }}}
 
-
-
-
-