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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: