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

slow query in dashboard

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.2
    • 1.8.1
    • Frontend (F)
    • None
    • 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

      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

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

              Created:
              Updated:
              Resolved: