Author: Michael T. Dean <mdean@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
_______________________________________________
mythtv-firehose mailing list
mythtv-firehose@mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-firehose
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
_______________________________________________
mythtv-firehose mailing list
mythtv-firehose@mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-firehose