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

      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).

        1. history2.1.patch
          2 kB
          Pavels Jelisejevs
        2. history2.2.patch
          2 kB
          Pavels Jelisejevs
        3. history2.patch
          2 kB
          Oleg Ivanivskyi
        4. test.txt
          98 kB
          Ткаченко Максим Александрович
        5. zabbix_2.2.4_latestdata.png
          195 kB
          Slash
        6. zabbix-2.0.4.PNG
          45 kB
          Rik Bruggink
        7. zabbix-2.2.5.PNG
          44 kB
          Rik Bruggink

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

              Created:
              Updated:
              Resolved: