NDO - Table Trimming Options

Le Merlus Romain rlemerlus at oreon-project.org
Fri Aug 24 10:56:10 CEST 2007


Hi Ethan,
Hi list,

First, for future NDO release, is it possible to manage/choose the SQL
table we want to fill ?
I mean, in large environment and for a certain kind of treatment, some
table can not be useful. I saw that we can set trimming properties in
ndo2db.cfg, but in my opinion, fill a table to truncate it just a
minute after, it's a lack of performance, and I like to optimize it.
<<
# Keep timed events for 24 hours
max_timedevents_age=1440

# Keep system commands for 1 week
#max_systemcommands_age=10080
max_systemcommands_age=1440

# Keep service checks for 1 week
#max_servicechecks_age=10080
max_servicechecks_age=1440

# Keep host checks for 1 week
#max_hostchecks_age=10080
max_hostchecks_age=1440

# Keep event handlers for 31 days
#max_eventhandlers_age=44640
max_eventhandlers_age=1440
>>
0 for no trim, -1 for no filling at all ?

Second, does anyone made benchmark on NDO ?

Thanks.
Greetings.
-- 
Romain Le Merlus
http://www.oreon-project.org

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/




More information about the Developers mailing list