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

Used query for history suboptimal and slow (up to 30 sec per item)

    XMLWordPrintable

Details

    Description

      It appears that the used query:

      select clock,ns,value from history_uint where itemid=786846 and clock<=1406552958 order by clock desc,ns desc limit 2;

      This works in many times faster:

      select clock,ns,value from history_uint where itemid=786846 and clock<=1406552958 order by clock desc limit 2;

      Please look the screenshots for details.

      Attachments

        1. explain.png
          explain.png
          42 kB
        2. time.png
          time.png
          77 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              oleg.ivanivskyi Oleg Ivanivskyi
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: