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

Very slow SQL query for getting last values from history and sometimes can be finished with error

    XMLWordPrintable

Details

    Description

      On Monitoring->Overview and Monitoring->Latest data we have function CHistoryManager->getLast() which gets values from history using union way. Sometimes:
      1. If the page contains a lot of items
      2. If some of values have latest values ages ago
      it can be very slow and can be failed with "memory is exhausted near" (increasing memory_limit to 512M, 1G does not help).

      Attachments

        1. history2.1.patch
          2 kB
        2. history2.2.patch
          2 kB
        3. history2.patch
          2 kB
        4. test.txt
          98 kB
        5. zabbix_2.2.4_latestdata.png
          zabbix_2.2.4_latestdata.png
          195 kB
        6. zabbix-2.0.4.PNG
          zabbix-2.0.4.PNG
          45 kB
        7. zabbix-2.2.5.PNG
          zabbix-2.2.5.PNG
          44 kB

        Issue Links

          is duplicated by

          Change Request - An Change Request or enhancement Improvement to an existing feature or task. ZBXNEXT-2013 Problems with "Latest data" after 2.2.0 upgrade

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-7810 Slow latest data section due to an inefficient query

          • Major - Major loss of function.
          • Closed

          Incident report - Incident report ZBX-8345 PHP fatal error on latest data page.

          • Major - Major loss of function.
          • Closed

          Incident report - Incident report ZBX-8016 Latest data is very slow when "Dropdown first entry" = "all"

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              Unassigned Unassigned
              dotneft Alexey Pustovalov
              Votes:
              36 Vote for this issue
              Watchers:
              46 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: