XMLWordPrintable

    • Sprint 85 (Feb 2022)
    • 0.5

      Following query is greatly slower after 0e36dceb985

      Unknown how long but already 13 minutes and one time waited for an hour and still no success.

      | 468 | zabbix          | localhost:55348 | zabbix | Query   |  795 | executing              | select t.triggerid,t.description,t.expression,t.recovery_expression from triggers t where t.triggeri |
       

      Tried the same on 5.0 and it was 1~ second

       44630:20220207:112253.470 slow query: 1.683397 sec, "select distinct t.triggerid,t.description,t.expression,t.recovery_expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10084 and (t.description in 

      Expected:
      ZBXNEXT-6196 mentions oracle so MySQL performance shouldn't have been affected

      Actual:
      MySQL performance have degraded greatly.

      Steps:
      Create empty database and try to discover lots of triggers for one discovery rule

            MVekslers Michael Veksler
            vso Vladislavs Sokurenko
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: