Steps to reproduce:
- Upgrade to Zabbix 6.0.1
- Login into Zabbix front end
- Observe very slow load times on zabbix dashboard and zabbix server timeout
- run top command and saw MariaDB process taking 100% of 1 CPU of a 2 CPU system
- Review zabbix server logs
- Identify query
- run tests while connected to zabbix database to verify log query times
See zabbix_server_timeout screenshot...
See zabbix_server_logs screenshot...
See attached zabbix_sql_query.txt...
No Zabbix server timeouts and normal load times