slow webinterface by normal user

[Midas1989]

hi,
i have a short question.


I create be Usergroup only readonly by 3 Hostgroups.
When i logged in with a user(Permission: Zabbix User or zabbix admin), the webinterface is very slow. in the Dashboar the dataload also.
The same User with Zabbix Super Admin the Interface is very fast.


Zabbix Version: 5.0.1
In the error log from httpd:
[Thu Jun 18 09:10:46.882459 2020] [proxy_fcgi:error] [pid 25982] (70007)The timeout specified has expired: [client 10.56.93.138:53417] AH01075: Error dispatching request to :, referer: https://zabbix.example.com/sysmaps.php
[Thu Jun 18 09:10:49.503216 2020] [proxy_fcgi:error] [pid 22844] [client 10.56.93.136:61099] AH01068: Got bogus version 38, referer: https://zabbix.example.com/zabbix.php?action=dashboard.view
[Thu Jun 18 09:11:51.991002 2020] [proxy_fcgi:error] [pid 21896] (70007)The timeout specified has expired: [client 10.56.93.138:53446] AH01075: Error dispatching request to :, referer: https://zabbix.example.com/zabbix.ph...dashboard.view


Can every member help me?

[Midas1989]

I identified two mysql statements.
SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=22 WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND i.hostid IN (10569,10570) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4)

SELECT t.triggerid FROM triggers t WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=22 WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND t.triggerid IN (29627,29628,30335,30336,30337,30338,30339,30340,3 0341,46191,46192,58590,66651) AND t.flags IN (0,4)