XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • Server (S)
    • Sprint 99 (Apr 2023), Sprint 100 (May 2023), Sprint 101 (Jun 2023), Sprint 102 (Jul 2023), Sprint 103 (Aug 2023)
    • 0.5

      I have a lot of Slow Queries occurrences in my log.
      If the query is rewritten these occurrences of Slow Query will disappear.

      1144405:20230322:170441.345 slow query: 11.273333 sec

       
      select i.itemid,
      i.hostid,
      i.status,
      i.type,
      i.value_type,
      i.key_,
      i.snmp_oid,
      i.ipmi_sensor,
      i.delay,
      i.trapper_hosts,
      i.logtimefmt,
      i.params,
      ir.state,
      i.authtype,
      i.username,
      i.password,
      i.publickey,
      i.privatekey,
      i.flags,
      i.interfaceid,
      ir.lastlogsize,
      ir.mtime,
      i.history,
      i.trends,
      i.inventory_link,
      i.valuemapid,
      i.units,
      ir.error,
      i.jmx_endpoint,
      i.master_itemid,
      i.timeout,
      i.url,
      i.query_fields,
      i.posts,
      i.status_codes,
      i.follow_redirects,
      i.post_type,
      i.http_proxy,
      i.headers,
      i.retrieve_mode,
      i.request_method,
      i.output_format,
      i.ssl_cert_file,
      i.ssl_key_file,
      i.ssl_key_password,
      i.verify_peer,
      i.verify_host,
      i.allow_traps,
      i.templateid,
      null from items i
      inner join hosts h on i.hostid=h.hostid
      join item_rtdata ir on i.itemid=ir.itemid
      where h.status in (0,1)
      and i.flags<>2
       

        1. Defaul Query time.png
          12 kB
          LivreAcesso.Pro
        2. Optimized Query time.png
          6 kB
          LivreAcesso.Pro
        3. zabbix_server.log
          78 kB
          LivreAcesso.Pro
        4. zabbix_server.log.zst
          535 kB
          LivreAcesso.Pro

            vso Vladislavs Sokurenko
            livreacesso.pro LivreAcesso.Pro
            Team A
            Votes:
            3 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: