Thanks Gerhard, I will try the new version soon, but that was really important for us to have a constant size of the db!
Denis 2011/6/5 Gerhard Lausser <gerhard.laus...@consol.de> > 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 >
------------------------------------------------------------------------------ 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
