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

    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

              • Assignee:
                Unassigned
                Reporter:
                dotneft Alexey Pustovalov
              • Votes:
                36 Vote for this issue
                Watchers:
                47 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: