User Role GUI is very slow

[Sunrise0318]

Hi all.

I update Zabbix 5.2 to 5.4 and user role users gui is very very slow, but superadmin users gui is fast.
What is the problem?
I remove all user settings, but is slow.
I remove user and add again, but slow.
If i change user role to superadmin role is fast...

please hel for me...
Thank You

[Sunrise0318]

Hello.
Please help for me.
(sorry my english is bad)

My infra
Zabbix 5.4.5 (update from 5.2)
Mariadb 10.5.9 (44 core 512 Gb ram and 2 TB data InnoDB)

After upgrade the frontend users is very slow.
If in night not work time the front end is fast the users but open one more page from Zabbix is slowly.
My mariadb CPU usage is very high 50% Percent in day.

I debug the frontend and run this select is slow:

SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid IN (11,13,14,19,20,41,42,52,68,80,92,142,207,312,350, 366,368,369,371) WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.status IN (0,1) AND ((UPPER(h.name) LIKE '*******' ESCAPE '!'))

But open the superadmin user this dashboard and select is(very fast):
SELECT h.hostid FROM hosts h WHERE h.flags IN (0,4) AND h.status IN (0,1) AND ((UPPER(h.name) LIKE '**********' ESCAPE '!'))

But superadmin dashboard graph is not update automatic...

Please help.

Thank you.

[dimir]

Superadmin user passes permission checks this is why it has always been faster for him. Current permissions implementation is not perfect. There are a lot of issues created by users about slow frontend on https://support.zabbix.com . For your case improving the database performance is probably the easiest solution.