Greg Pangrazio wrote:
Is there a way to limit which hosts get put into the NDO database? My
install is getting a bit big and NDO is taking up too much of the CPU
and making the system sluggish. If i turn of NDO it works fine.
I use ndo for some custom pages for groups that do not have
ndo2db:
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/var/cache/nagios3/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=localhost
db_port=
db_name=ndoutils
db_prefix=nagios_
db_user=php_user
db_pass=ph...@ssw0rd
max_timedevents_age=60
max_systemcommands_age=90
Hi,
Greg Pangrazio wrote:
max_timedevents_age=60
If you remove that from data_processing_options, it won't be used in the
future.
max_systemcommands_age=90
max_servicechecks_age=90
max_hostchecks_age=90
max_eventhandlers_age=1440
Quite low values, could be that the cleanup
I don't really care about historical data so i was reducing those
times to get data out of the DB faster and improve startup times.
Should I go back to the defaults there?
Here is the SQL
+--+
| CNT |
+--+
| 3232 |
+--+
Really I only need service and host status nothing else is of
Greg Pangrazio wrote:
I don't really care about historical data so i was reducing those
times to get data out of the DB faster and improve startup times.
Check on indexes for the MySQL schema. there is a -mod sql script next
to the normal db schema definition.
Should I go back to the
So i set data_processing_options to 12480
moved the timeouts back to the standards
I am still seeing the same behavior.
As soon as I start ndoutils the service and host checks stop. In the
performance info the number of checks in the last 1min goes to 0 and
if i wait long enough the 5 min also
Is there a way to limit which hosts get put into the NDO database? My
install is getting a bit big and NDO is taking up too much of the CPU
and making the system sluggish. If i turn of NDO it works fine.
I use ndo for some custom pages for groups that do not have access to
nagios and only need
Unless you wish to somehow modify the source code to ignore certain
hosts (a very risky proposition unless you are good at C), I'd recommend
against trying to limit the number of hosts that NDO puts in the
database. Also, having that many services in NDO shouldn't be an issue
with the hardware