Hi,

there were some issues with the file size of the sqlite database file where
the livestatus module writes the log broks to. This is how you can keep this
under control:
In the section of shinken-specific.cfg where you define the Livestatus
module, please add
max_logs_age 7d
as described in
http://www.shinken-monitoring.org/wiki/the_broker_modules?s[]=max&s[]=logs&s
[]=age (7d is just an example)
Then update livestatus_broker.py. I committed a patch tonight which should
keep the database file at a constant size. 
(There is a daily delete operation on the database file, where logs older
than max_logs_age are deleted. What I didn't think of is, sqlite marks pages
as free after a delete-statement, but the size of the database file remains
the same. I added a vacuum-statement, which will shrink the database file
after a delete of the deprecated logs)

Gerhard 


------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today. 
http://p.sf.net/sfu/quest-dev2dev2 
_______________________________________________
Shinken-devel mailing list
Shinken-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/shinken-devel

Reply via email to