Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22126

Trends recalculations when older data from the proxy is coming

    XMLWordPrintable

Details

    • Team A
    • Sprint 95 (Dec 2022), Sprint 96 (Jan 2023)
    • 0.5

    Description

      Let's take a quite loaded installation.
      The proxy sends data (due to some problems) that is older than the current hour.
      The server recalculates trends => these are heavy queries => busy history syncers, database performance problems

      48010:20221222:050526.705 slow query: 44.008837 sec, "select distinct itemid from trends_uint where clock>=1671678000 and (itemid in XX)
      ......
      48010:20221222:050618.124 slow query: 51.351171 sec, "select distinct itemid from trends_uint where clock>=1671678000 and (itemid in XX)
      .....
       48010:20221222:050716.513 slow query: 58.368658 sec, "select distinct itemid from trends_uint where clock>=1671678000 and (itemid in XX}
      

      Attachments

        Issue Links

          Activity

            People

              vso Vladislavs Sokurenko
              elina.kuzyutkina Elina Kuzyutkina
              Votes:
              4 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: