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

Widget Problems : very bad request execution time

    XMLWordPrintable

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 43, Sprint 44, Sprint 45, Sprint 46, Nov 2018, Sprint 47, Dec 2018, Sprint 48, Jan 2019, Sprint 56 (Sep 2019), Sprint 55 (Aug 2019), Sprint 49 (Feb 2019), Sprint 50 (Mar 2019), Sprint 51 (Apr 2019), Sprint 52 (May 2019), Sprint 53 (Jun 2019), Sprint 54 (Jul 2019), Sprint 57 (Oct 2019), Sprint 58 (Nov 2019), Sprint 59 (Dec 2019), Sprint 60 (Jan 2020), Sprint 61 (Feb 2020), Sprint 62 (Mar 2020), Sprint 63 (Apr 2020), Sprint 64 (May 2020), Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020)
    • Story Points:
      3

      Description

      Steps to reproduce:

      1. Add the "Problems" widget to your dashboard
      2. have few dozens of millions records in table events (I have 25M records)
      3. open multiple guests account on different browser and computer to access the dashboard with the widget

       

      Result:
      MySQL will use a lots of CPU (1Core per request on the widget "Problems")

      Expected:
      the requests should be very fast like the reste of the sql requests that run everywhere on this version.

        Attachments

        1. fix-slow-dashboard-problems.patch
          2 kB
        2. zbx-13789-4.0.21.patch
          37 kB
        3. zbx-13789-4.4.patch
          38 kB
        4. zbx-13789-4.4-v2.patch
          40 kB
        5. zbx-13789-4.4-v3.patch
          40 kB

          Issue Links

            Activity

              People

              Assignee:
              sasha Alexander Vladishev
              Reporter:
              psychomoise psychomoise
              Votes:
              16 Vote for this issue
              Watchers:
              29 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: