Graphs problem

[pabloadmin]

Hi Alexei,

After two days ago, the graphs for 1-7.5 hs were working, but after we disable some items (we didn't delete it), the graphs stoped to show the lines.
If we chose >=8hs option at charts.php, the line appear. But when we chose <=7,5, it doesn't appear. What it means?
How can we repair it?
We have MySQL with MYISAM format and the History table has 8.5Gb, we have seven months on line.



thank you in advanced.

[illumin8]

You are probably trying to graph something where the update interval is smaller than the data set you are graphing. If you're using zabbix_sender to send data every 1 minute, and the update interval is set to 30 seconds, Zabbix won't draw lines because it doesn't have half of the data points to draw. Increase the update interval for that item and this should work OK.

[pabloadmin]

Thank you, but didn't work. I did do more tests and i think there is a problem with the graph scale. But i couldn't fix it, have another suggestion?

thank you.

[axel]

<- Same Problem

afer Upgrate from 1.0 to the Alpha versions the graphs 1h -4h draws no lines.
Only 8h-Jear Draw the lines

[pabloadmin]

You have a problem with the history table. You need compare the structure in the database with the file schema.sql. Verify the table type (MyISAM or Innodb), if you have MyIsam, maybe the table can be corrupted.

bye.

[axel]

ok thx i try this

but can this be a Problem ?

9.594.476 MyISAM 303,2 MB 6.038 KB

the table is very BIG to big maybe ?

[axel]

OK i need some help ;)

How can i Fix the history Table ?

i doesnt work with the schema.sql

i need the 1-4h history

[zebulon]

I have just upgraded to alhpa 1.11 and i have add a new machine with 2 items generated by a perfcounter of my network card all data are recorded but I can't see nothing on my graphs.
if I see a graph who have created before installation of last version of zabbix graphs works correctly.

have you an idea ?

[axel]

Nothing changed I checkt the table everything is ok but no 1h-4h graphs :(

[pabloadmin]

I recommend to you migrate from MyISAM to InnoDb, because MyISAM is very
inestable. To do this, you need:

- export all data
- drop all tables
- run again the schema.sql
- import the data exported, except the history table.
You can import it, but step by step, i mean, take the fist 100
rows. If it works, cotinue with the next 100 rows, test and repeat the step.

What MySQL version do you use?, if it is before than 4, you need enable the InnoDb support.


best regards.

[zebulon]

All my tables are in Innodb, and my version of MySQL is 4.1.12 on debian server.


You can see an example of my graph.I see only some parts of my curve,but if I see data values I have all values on database.

if you need more details, talk to me what you want and I give all information to solve this problem.

thank you.

zabbix is beautiful :)

[axel]

ok i kill history know ;)

delete history table and recreate it.

now the table is innodb and no 1h-4h support ;)

MySQL 4.0.24_Debian-10-log

here you can see both 4h and 8h history

http://vpsd10.deinfo-networks.de/zabbix/4h.jpg
http://vpsd10.deinfo-networks.de/zabbix/8h.jpg

[axel]

I think i know the Problem but dont know how to Fix it.

I send the Data every 3 Minutes to Zabbix using zabbix_trapper . if i make a simple ping check every 60 secs the Graph is draw the 1h-4h history.

How can i Fix this Problem ?


UPDATE!!

ok i Fix the Problem

I change cronjob of update every 1 Mintue after that it works.
But i think its not the best way to fix it ;)

[Alexei]

I believe Delay is set to very low value. For example, Delay=30 seconds, but you send values each 3 minutes. In this case, ZABBIX will not draw any lines.

Set the Delay to, say, 5 minutes to make graphs work.

[axel]

ok i see the Problem.

I have only one question.

I Use zabbix_sender where i have the Problems, and i only can manage the time with my cronjobs. Because at the Items i use the zabbix_trapper to recieve the Data and there i cant change updateinterval from 30sec to 5 mins.



How can i change it ? Because i must change it i have many Servers to Monitor and 5 mintues are ok 1 min is to short to many traffic.
I think i have to change it in the Database ?


cron.d/zabbix
*/1 * * * * root /root/zabbix_vpsd1.sh
*/1 * * * * root /root/zabbix_vpsd2.sh
*/1 * * * * root /root/zabbix_vpsd3.sh
...

zabbix_vps11.sh for example
/usr/local/zabbix/bin/zabbix_sender localhost 10004 DEINFO-VPS11:partbackup `grep /backup /tmp/vps11_zabbix.data |cut -d\
-f2

if i set the cronjobs to
*/2 * * * * root /root/zabbix_vpsd3.sh`

i got only line parts - - - - ;)

[zebulon]

:( Alexei, when you speak of delay, it's 'Update interval (in sec)' fields no ?

if it's not that where is delay parameter.
perhaps it's same solution but i'm not sure.

I have see my perfcounter update value it 's 15s, update interval of my perfnetIn1 value is 30s and when I see all values store I only see one value by 3mn ???

help me.

[Alexei]

:( Alexei, when you speak of delay, it's 'Update interval (in sec)' fields no ?

Sorry, yes, I was referring to 'Update interval'.

[zebulon]

Sorry, yes, I was referring to 'Update interval'.

Ok thanks.

For my problem.

My perfcounter to record all network traffic on my windows 2000 server is configured to get a store a new value all 15s and zabbix store a new value all 30s.

and now if I see all values on zabbix I can see on value by item all 3mn, and graphs are discontinued. have you an idea ?