search

grafana / grafana-zabbix

Zabbix plugin for Grafana dashboard
http://play.grafana-zabbix.org
Apache License 2.0
2.06k stars 458 forks source link

Host with 60k+ items #410

Open darrynv opened 7 years ago

darrynv commented 7 years ago

I'm submitting a ...

Software Versions | Grafana | Zabbix | Grafana-Zabbix Plugin | | Version 4.3.2 (commit: ed4d170) | 3.2.6 | 3.4.0 |

What did you do?

Tried to create a dashboard for a host with 65,000 items

What was the expected result?

Slow load times when selecting an Item for display. Filtered by Application = 24k possible items.

What happened instead?

Zabbix API Error

Suspect this is due to the sheer size of data returned?

alexanderzobnin commented 7 years ago

You get Zabbix API Error, so I think, it's due memory issues with PHP. Try to look at php logs, maybe you should increase an amount of memory. How many items do you want to display? Maybe it makes sense to add a mode where the plugin will use itemids instead regex filtering. Also, in order to prevent grabbing all items when request is building, try to increase cache TTL in data source config.

darrynv commented 7 years ago

Currently this is for 1200 items.

/var/log/httpd/error.log

Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /usr/share/zabbix/include/classes/api/services/CHistory.php on line 197, referer.

Increased php_value memory_limit to 1024MB and the error went away.

Thank you!

I'm going to have a problem down track though if we regex, say 10k items so using itemids might be very useful! I'll play with TTL and let you know how that goes on large queries!

github-actions[bot] commented 1 month ago

This issue has been automatically marked as stale because it has not had activity in the last 2 years. It will be closed in 60 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!