-
Type:
Problem report
-
Resolution: Commercial support required
-
Priority:
Trivial
-
None
-
Affects Version/s: 4.4.4
-
Component/s: Server (S)
-
None
-
Environment:zabbix4.4.4
mysql 8.0.18
zabbix4.4.4 The same sql is particularly slow on mysql8.0 and particularly fast on mysql5.7. Is there any problem?
SQL: SELECT g.groupid,g.name FROM hstgrp g WHERE EXISTS (SELECT NULL FROM hosts h,items i,graphs_items gi,graphs gr,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND hg.hostid=i.hostid AND i.itemid=gi.itemid AND gi.graphid=gr.graphid AND gr.flags IN (0,4) AND g.groupid=hg.groupid) AND EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND g.groupid=hg.groupid);
mysql5.7
mysql8.0
