Zabbix 5.0.26 Slow Query | Slow Dashboard

[maxhandschild]

About our system:
We use PHP-7.4.33 , Zabbix 5.0.26 , MySQL 8.0.32.
To get a picture of our environment, we currently have 3324 hosts, a total of 232506 elements and 108313 triggers.

The current problem is that the dashboard takes several seconds in debug mode. Latest Data is up to date and does not cause any problems. I have figured out which host group caused the problem of the slow queries, but don't know how to solve.
To our dashboard, we have multiple host groups in that dashboard and two of them causing the issue.

We already tried to increase the memory limit of php from 1024MB to 2048MB. But didn't worked out.

Maybe someone has a solution or an idea what check to next?

[maxhandschild]

We have found the error and solved it.
The problem was caused by some triggers that were created incorrectly and delivered a report every minute for the last 7 days, resulting in over 60000 reports. This slowed down the performance of the database for larger links.