value cache overload sql server

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Major
    • None
    • Affects Version/s: 2.2.0
    • Component/s: Server (S)
    • Environment:
      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

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

              Created:
              Updated:
              Resolved: