question on graphs - min,avg, max

[chriso]

Hello,

I have a question on the graph for a data item. I'm analyzing both the graph and actual data from the zabbix secion "monitoring -> latest data).

I don't understand where the graph gets the min/max/avg values for a particular data element, in this case, cpu load.

When I compare the graph with the actual data points, it just isn't making sense. In this example, at about 7:15 the actual data aligns with the line on the very top, which I thought was "max". If that is true, what do the middle and bottom lines represent? The more I look at it..the actual data and graph lines just don't match. I've attached both my data set and screenshots of the graph.

If anyone can enlighten me I would be greatly appreciated. Thanks

[alixen]

Hi,

I don't understand where the graph gets the min/max/avg values for a particular data element, in this case, cpu load.

Zabbix gets these data from trends table.
This table contains one record per hour with min/avg/max values during that hour.

Here is an example from my database:

select i.itemid,
       from_unixtime(clock),
       t.num,
       t.value_min,
       t.value_avg,
       t.value_max
  from hosts h,
       items i,
       trends t
 where i.hostid=h.hostid
   and t.itemid=i.itemid
   and h.host='srv1'
   and i.description='CPU Load'
 order by clock desc
 limit 10;
+--------+----------------------+-----+-----------+-----------+-----------+
| itemid | from_unixtime(clock) | num | value_min | value_avg | value_max |
+--------+----------------------+-----+-----------+-----------+-----------+
|  19571 | 2010-03-31 10:00:00  |  12 |    0.6400 |    1.6033 |    3.2400 |
|  19571 | 2010-03-31 09:00:00  |  12 |    0.3700 |    1.0092 |    2.0200 |
|  19571 | 2010-03-31 08:00:00  |  12 |    0.2800 |    0.9067 |    2.6000 |
|  19571 | 2010-03-31 07:00:00  |  12 |    0.1200 |    0.8250 |    1.7100 |
|  19571 | 2010-03-31 06:00:00  |  12 |    0.0300 |    0.4567 |    1.2700 |
|  19571 | 2010-03-31 05:00:00  |  12 |    0.0900 |    0.9100 |    2.1800 |
|  19571 | 2010-03-31 04:00:00  |  12 |    0.0400 |    0.5200 |    1.8700 |
|  19571 | 2010-03-31 03:00:00  |  12 |    0.2800 |    1.1008 |    2.5800 |
|  19571 | 2010-03-31 02:00:00  |  12 |    0.0600 |    0.6783 |    2.1300 |
|  19571 | 2010-03-31 01:00:00  |  12 |    0.2200 |    0.9392 |    2.5600 |
+--------+----------------------+-----+-----------+-----------+-----------+

Regards,
Alixen