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

count() trigger expression makes inefficient queries on MySQL databases

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 2.0.3
    • None
    • Server (S)
    • None

    Description

      We had a trigger with the expression:

      {T_OS_Generic:icmppingloss.count(86400,0,"gt")}

      >20 &

      {T_OS_Generic:icmppingloss.avg(#3)}

      <100

      Unfortunately this result in a database query like:
      select value from history where itemid=1604447 and clock>1352704830 and clock<=1352791230

      Which is inefficient and bogs down the whole DB, especially doing multiple such queries for data gathered every 60 seconds from hosts (this results in 1440 fetched rows per checked item)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              deejay1 Łukasz Jernaś
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: