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 the same problem

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

[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-VPS11artbackup `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 - - - -