zabbix site is loading too slow

[trivi]

Hi,

I am using zabbix 3.0.7 version with mysql DB. When i am fetching previous data through the web UI, the site is loading for hours.

Please help me in resolving this. It will be very appreciated.

[kaspars.mednis]

Hello !

You can use the zabbix frontend debug tool to find the "killer" query

https://www.zabbix.com/documentation/3.4/manual/web_interface/debug_mode

And i suggest to look at MySQL DB side, because almost all data for zabbix frontend is gathered from there.

How large is the DB size?
How much RAM has the DB server ?
How large is your innodb_buffer_pool_size in my.cnf?

Regards,
Kaspars

[trivi]

Hello !

You can use the zabbix frontend debug tool to find the "killer" query

https://www.zabbix.com/documentation/3.4/manual/web_interface/debug_mode

And i suggest to look at MySQL DB side, because almost all data for zabbix frontend is gathered from there.

How large is the DB size?
How much RAM has the DB server ?
How large is your innodb_buffer_pool_size in my.cnf?

Regards,
Kaspars

Hi
Thanks for the response.
DB used only 25%.
16GB of RAM allocated.
i didnt find parameters of innodb in my.cnf..

Could you please help me in this. I am using centos7.

[allexpetrov]

Hi,

Please check the Apache error logs. Can you spot any errors there?

Regards,
Alex!

[trivi]

Hi

Didn't find any errors with httpd.
Able to get the httpd but unable to fetch the previous data of resources.