Nagios Support Forum

------=_Part_376547_99566.1177944775496
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi devels,
Im developer of visualization tool Nagvis. I worked a bit on the NDO backend
to optimize the queries to the DB. I recognized that the field instance_id
is not a part of an index/key in some (or some more) tables.

For example we query the following tables in one query:
- nagios_objects and nagios_hoststatus (To get the hoststatus)

- nagios_objects and nagios_servicestatus (To get the servicestatus)

- nagios_objects and nagios_hostgroups (To get the ID of a hostgroup)
- nagios_objects and nagios_hostgroup_members (To get the members of a
hostgroup)

- nagios_objects and nagios_servicegroups (To get the ID of a servicegroup)
- nagios_objects and nagios_servicegroup_members (To get the members of a
servicegroup)

In all cases were filtering the datasets by the instance_id. But not in all
tables the field "instance_id" is indexed or a (part of a) key. I'm not the
mysql geek but I think it would be good to make the field "instance_id" in
table nagios_objects as a key - or a part of a key.
This should make the selects much more faster.

I just had a look at the queries distributed in the ndo package, I
recognized there are always joins to nagios_hosts/nagios_services etc. I
think a JOIN to the table only for checking if this is the correct
"instance_id" is to much overhead.

Some comments/ideas?

Regards,
Lars

------=_Part_376547_99566.1177944775496
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi devels,
Im developer of visualization tool Nagvis. I worked a bit on the NDO
backend to optimize the queries to the DB. I recognized that the field
instance_id is not a part of an index/key in some (or some more) tables.

For example we query the following tables in one query:
- nagios_objects and nagios_hoststatus (To get the hoststatus)

- nagios_objects and nagios_servicestatus (To get the servicestatus)

- nagios_objects and nagios_hostgroups (To get the ID of a hostgroup)
- nagios_objects and nagios_hostgroup_members (To get the members of a
hostgroup)

- nagios_objects and nagios_servicegroups (To get the ID of a servicegroup)
- nagios_objects and nagios_servicegroup_members (To get the members of
a servicegroup)

In all cases were filtering the datasets by the instance_id. But not in
all tables the field "instance_id" is indexed or a (part of a) key. I'm
not the mysql geek but I think it would be good to make the field
"instance_id" in table nagios_objects as a key - or a part of a key.
This should make the selects much more faster.

I just had a look at the queries distributed in the ndo package, I
recognized there are always joins to nagios_hosts/nagios_services etc. I
think a JOIN to the table only for checking if this is the correct
"instance_id" is to much overhead.

Some comments/ideas?

Regards,
Lars

------=_Part_376547_99566.1177944775496--





This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]