XMLWordPrintable

Details

    • Team B
    • Sprint 85 (Feb 2022)
    • 0.5

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: