-
Problem report
-
Resolution: Commercial support required
-
Trivial
-
None
-
4.4.4
-
None
-
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