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

value cache overload sql server

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 2.2.0
    • Server (S)
    • debian wheezy, mariadb 5.5

      vc_db_read_values_by_count() and vc_db_read_values_by_time() reads to MUCH data from sql when it can't find need value in first iteration.
      In my situation SQL server halted over weekend and there no data in last two days. when server evaluate last(0,86400) function - it's try read ALL values and nothing found.
      So, why it try read unneeded data?

        1. by_count_limit.patch
          1 kB

            Unassigned Unassigned
            lynxchaus Andrey Melnikov
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: