Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1027

New dashboard: MySQL User Details (INFORMATION_SCHEMA.CLIENT_STATISTICS)

    XMLWordPrintable

Details

    • 1
    • Platform Sprint 18, Platform Sprint 19, Platform Sprint 20
    • Yes
    • Yes

    Description

      Intoduction

      As per INFORMATION_SCHEMA.CLIENT_STATISTICS

      Tasks

      1. Create dashboard named MySQL Client Statistics
      2. Graphs:
        1. Top Clients by Connections Created
        2. Top Clients Connections Concurrency(CONCURRENT_CONNECTIONS)
        3. Top Clients by Traffic
        4. Top Clients by Rows Fetched/Read
        5. Top Clients by Rows Updated
        6. Top Clients Connection Time (CONNECTED_TIME)
        7. Top Clients by Busy Time
        8. Top Clients by CPU time - this and the two above might make sense on same graph?
        9. Top Clients by Command type (*_COMMANDS)
        10. Top Clients Rollback and Commit
        11. Top Clients Denied Connections, Lost, Access Denied, Empty Queries

      Attachments

        1. gray.gif
          gray.gif
          124 kB
        2. image-2020-06-30-12-33-35-986.png
          image-2020-06-30-12-33-35-986.png
          44 kB
        3. image-2020-06-30-12-34-23-547.png
          image-2020-06-30-12-34-23-547.png
          243 kB
        4. image-2020-07-02-13-47-37-380.png
          image-2020-07-02-13-47-37-380.png
          8 kB
        5. image-2020-07-02-13-49-19-102.png
          image-2020-07-02-13-49-19-102.png
          15 kB
        6. image-2020-07-02-14-26-28-705.png
          image-2020-07-02-14-26-28-705.png
          107 kB
        7. Screenshot_20200505_165747.png
          Screenshot_20200505_165747.png
          23 kB
        8. Screenshot_20200616_180442.png
          Screenshot_20200616_180442.png
          110 kB
        9. Screenshot_20200617_221248.png
          Screenshot_20200617_221248.png
          133 kB
        10. Screenshot_20200618_110814.png
          Screenshot_20200618_110814.png
          118 kB
        11. Screenshot_20200618_111115.png
          Screenshot_20200618_111115.png
          145 kB
        12. Screenshot_20200619_123409.png
          Screenshot_20200619_123409.png
          45 kB
        13. Screenshot_20200619_174309.png
          Screenshot_20200619_174309.png
          91 kB
        14. Screenshot_20200619_174514.png
          Screenshot_20200619_174514.png
          25 kB
        15. Screenshot_20200630_134241.png
          Screenshot_20200630_134241.png
          76 kB
        16. usernames.gif
          usernames.gif
          416 kB

        Issue Links

          is cloned by

          Improvement - An improvement or enhancement to an existing feature or task. PMM-1028 Create dashboard for userstat THREAD_STATISTICS

          • Low - Cosmetic problem like misspelled words or misaligned text.
          • On Hold

          Improvement - An improvement or enhancement to an existing feature or task. PMM-1029 Add graphs for userstat INDEX_STATISTICS to MySQL Table Statistics dashboard

          • Low - Cosmetic problem like misspelled words or misaligned text.
          • On Hold
          blocks

          SFR-251 Loading...

          links to

          Web Link Grafana issue of bar panel

          Activity

            People

              Unassigned Unassigned
              michael.coburn@percona.com Michael Coburn
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 3 days, 6 hours, 50 minutes
                  3d 6h 50m

                  Smart Checklist