Can be a bug?

[pabloadmin]

I have a doubt, when i change the scale on some graph (to a day for example) the values that are shown in the graphic, are less than in an hour. this is a simplification by the great quantity of values to show?.
I was monitoring a JBoss application server and i did do a UserParameter to get the active threads on the application server. I do this because i want to get all online users at every moment. We want adjusting, in the application server, the maximun active threads and zabbix can help for this.
The point is, when i want see the activity on a week, some information is loss at the graph. If i choose the option 8 hours, i see a peak for a short time (for a minute), but when choose the option a week, i don't see it.
How do zabbix a graph representation?, take the average of last function for a the week? or cut some information?
This is a limit by the image type representation (png or jpg)?

thank you.

[pabloadmin]

Is this normal for graphs?


thank you.

[Alexei]

Graphs are based on average values. For period longer than 7 hours the graphs are generated from hourly averages stored in table 'trends'.

[pabloadmin]

I understand. A question?, is possible to add a check box at the charts.php to select if i want the trends or the history?.
Because maybe i can want the trends for cpu processor but maybe i can want numeric values like active users, to obtaining the peaks by hour for a application, if i can get the values for a week, i will have users activity trend by hour for a week.


thank's a lot.


This is the code at classes.inc.php file to do the selection, wright?


if($this->period<=24*3600)
{
$sql="select itemid,round(900*((clock+$z)%($p))/($p),0) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max,max(clock) as clock from history where itemid in ($str) and clock>=".$this->from_time." and clock<=".$this->to_time." group by itemid,round(900*((clock+$z)%($p))/($p),0)";
}
else
{
$sql="select itemid,round(900*((clock+$z)%($p))/($p),0) as i,sum(num) as count,avg(value_avg) as avg,min(value_min) as min,max(value_max) as max,max(clock) as clock from trends where itemid in ($str) and clock>=".$this->from_time." and clock<=".$this->to_time." group by itemid,round(900*((clock+$z)%($p))/($p),0)";
}
// echo $sql;

[Alexei]

I would add a selection of avg, min or max. Currently ZABBIX selects AVG from both history and trends.

[pabloadmin]

You are the best!!!