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

slow query in dashboard

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.1
    • Fix Version/s: 1.8.2
    • Component/s: Frontend (F)
    • Labels:
      None
    • Environment:
      freebsd 7.1
      mysql-server-5.0.77_1
      Zabbix Server (daemon) v1.8.1 (revision 9702) (27 January 2010)

      CPU: Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz
      memory = 2GB

      Description

      after upgrading from 1.8.0 to 1.8.1 we detect some slow queries from dashboard

      show processlist shows several queries like:

      16822 zabbix localhost zabbix query 22 copying to tmp table select distinct h.*,hg.groupid from hosts h,hosts_groups hg where ((h.hostid between 600000

      execution time about 10-50 seconds

      i have added 3000 hosts, opened 10 dashboards and saw this
      http://s11.radikal.ru/i183/1002/4b/ae68b810cde5.jpg

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            ugh Konstantin Agafontsev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: