Hi all,
We've using zabbix for years now, but since a while we're seeing some weird stuff.
First some stats:
Hosts: 373
Items: 19474
Triggers: 7126
Required performance: 307/sec
In the interface we're seeing the famous dots in the graphs, pointing to not enough resources available. But when I look at the box itself it has a load average of 0.2, no I/O wait on the CPU, mysql processlist usually empty and a sh*tload of free memory available. I've been looking at MySQL tuning, but I can't do anything besides I already did.
Is there a way I can verify whether the data in the graphs is actually in the DB? In other words: get the raw output of latest data? Or the query it used to generate the graph?
For future notice, hardware specs:
2 x Xeon E5620 quad core @ 2.4
96 GB RAM
4 x 300 GB SAS II 15k RPM in RAID 10
Another interesting note: look at these 2 screenies: https://jkooijman.admin.cloud.nl/nr1.png & https://jkooijman.admin.cloud.nl/nr2.png. Same pattern, but look at the timestamps. one graph contains data the other doesn't show.
We've using zabbix for years now, but since a while we're seeing some weird stuff.
First some stats:
Hosts: 373
Items: 19474
Triggers: 7126
Required performance: 307/sec
In the interface we're seeing the famous dots in the graphs, pointing to not enough resources available. But when I look at the box itself it has a load average of 0.2, no I/O wait on the CPU, mysql processlist usually empty and a sh*tload of free memory available. I've been looking at MySQL tuning, but I can't do anything besides I already did.
Is there a way I can verify whether the data in the graphs is actually in the DB? In other words: get the raw output of latest data? Or the query it used to generate the graph?
For future notice, hardware specs:
2 x Xeon E5620 quad core @ 2.4
96 GB RAM
4 x 300 GB SAS II 15k RPM in RAID 10
Another interesting note: look at these 2 screenies: https://jkooijman.admin.cloud.nl/nr1.png & https://jkooijman.admin.cloud.nl/nr2.png. Same pattern, but look at the timestamps. one graph contains data the other doesn't show.
Comment