[mythtv-firehose] mythtv/new-logging commit: 6b660a1ef by Michael T. Dean (sphery)

[MythTV]

      Author:  Michael T. Dean <mdean at mythtv.org>
 Change Date:  2011-05-10T10:38:02-07:00
   Push Date:  2011/05/10 10:38:39 -0700
  Repository:  mythtv
      Branch:  new-logging
New Revision:  6b660a1efbc01559fd107bb998362be5643c650d
   Changeset:  https://github.com/MythTV/mythtv/commit/6b660a1ef

Log:

Add database log expiry back to housekeeping.

Clean up database log entries with a daily housekeeping task.  For now,
we're keeping 2 weeks worth of log entries, but we also have a max
number of rows allowed (10K/day = 140K rows).  While this sounds like a
lot, it shouldn't have a major impact on database size--probably adding
up to about 25MiB to the DB size (and about 8MiB for indices).

These values may be adjusted in the future, as we get a better feel for
log message representation within these limits.  Also, we may modify the
expiry algorithm to preferentially expire logging from certain
"less-important" applications (i.e. adding a 1wk expiry for
mythcommflag/mythpreviewgen logging or similar).  However, this
implementation is a good start and will prevent unbounded growth of DB
logs.

Modified:

   mythtv/programs/mythbackend/housekeeper.cpp
   mythtv/programs/mythbackend/housekeeper.h