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

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

      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}
      

            vso Vladislavs Sokurenko
            elina.kuzyutkina Elina Kuzyutkina (Inactive)
            Team A
            Votes:
            4 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: