Overview of volume of incoming monitoring data per host?

[rpost]

Does Zabbix keep the number of bytes of monitoring data it receives?

Is there a way to make this available as an item per host, or as a report?

Can this information be retrieved with a database query?

The goal is to see how much each host is contributing to the load on the server. When the server is struggling to cope with the volume of monitoring data (which has happened to us in the past) it would be helpful to see if there are any outlier hosts that generate an excessive amount of data.

[bbonno]

To my knowledge this functionality is not present in Zabbix. You only have the effect of your data collection on the server, so you can have any suspicions confirmed by disabling a host and see how the overall metrics change. The 'Values per second' should be a good indicator.

[Glencoe]

Yes, Zabbix doesn't store "the number of bytes of monitoring data" separately.

However, for one-off investigations, it's fairly trivial to count the number of recent values received per host for the top hosts:

select h.hostid, h.host, count(*)
from history_uint hsu, hosts h, items i
where hsu.itemid = i.itemid and i.hostid = h.hostid and i.status = 0 and
hsu.clock >= unix_timestamp(now() - interval 1 day)
group by h.hostid order by 3 desc limit 10

You need to repeat for every data type (history_text, history_log etc).

[PavelZ]

Here is one way to count bytes - https://github.com/pavlozt/zabbix-db-auditor/
It does the same thing as queries, but is useful if you want to view these reports on a regular basis.
However, it (for now) only works with mysql and even with SQL you can't count bytes accurately.

But this program can be effectively used to decide what to delete or change.

[rpost]

It's been a month ... I just want to thank for the prompt responses. Much appreciated. I will need to fined some quiet time in which I can apply this. I was hoping to quickly be able to get up a graph with the data contribution per host so we can see if there are any outliers, but it takes a little more work.