graphing
I had been having an issue with 1 hour graphs since I started running the alpha11 frontend
they had odd graphical dropouts to spite the fact there was data present in the DB for these times, furthermore the more hosts I added to the system the more prevelent these dropouts seemed to get. for example
in chasing this down I was led to the select statement in include/classes.inc.php on line 510(I think). the line reads:
by modifying it slightly and removing the max(clock) as clock item from the select I was able to get the graphs working properly.
new select statement:
resulting graph:
could somebody with a little more knowledge into the structure of zabbix shine some light on to just why this particular data point caused such strange behaviour on the graphs and what is it intended to do? I just started wading through the code and making some customizations and fixing this was key but I don't want to break other functionality because of this change either.
was anyone else having this issue?
ps: sorry for the wide graphs, it's getting late and I'm about to go home.. didn't have time to resize them.
they had odd graphical dropouts to spite the fact there was data present in the DB for these times, furthermore the more hosts I added to the system the more prevelent these dropouts seemed to get. for example
in chasing this down I was led to the select statement in include/classes.inc.php on line 510(I think). the line reads:
Code:
$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>=".$thi s->from_time." and clock<=".$this->to_time." group by itemid,round(900*((clock+$z)%($p))/($p),0)";
new select statement:
Code:
$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 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)";
could somebody with a little more knowledge into the structure of zabbix shine some light on to just why this particular data point caused such strange behaviour on the graphs and what is it intended to do? I just started wading through the code and making some customizations and fixing this was key but I don't want to break other functionality because of this change either.
was anyone else having this issue?
ps: sorry for the wide graphs, it's getting late and I'm about to go home.. didn't have time to resize them.
)
Comment