Hi,
> And for the livestatus.db, I have tried your command to count the entries
and it gave me. A cleaning up in cron might be a good idea, like you said
:-p
> sqlite3 /usr/local/shinken/var/livestatus.db "select count(*) from logs
where time < strftime('%s', 'now') - 3600*24*7"
> 483973
I'm an idiot. This statement I sent you counts the log entries older than a
week. To delete the old entries it must be:
"delete from logs where ....."
Gerhard
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Shinken-devel mailing list
Shinken-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/shinken-devel
