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

Many ProxySQL graphs are empty for proxysql2

    XMLWordPrintable

    Details

      Description

      Reproducable:

      • set up 3 node PXC (mysql1, mysql2, mysql3)
      • install pmm2, sysbench, proxysql2 on 'app' server
      • configure pmm-client on appropriate machines, (add mysql, add proxysql)
      • add pxc servers like this to proxysql:
        INSERT INTO mysql_servers  (hostgroup_id, hostname, weight) VALUES  (2, '<Internal_IP_mysql3>', 1000),  (3, '<Internal_IP_mysql1>', 1000),  (3, '<Internal_IP_mysql2>', 1000),  (3, '<Internal_IP_mysql3>', 1000),  (4, '<Internal_IP_mysql1>', 1000),  (4, '<Internal_IP_mysql2>', 1000);
        
        -- 2 is WRITER, 3 is READER, 4 is BACKUP_WRITER
        
        INSERT INTO mysql_users (username, password,default_hostgroup) VALUES ('sbuser', 'sbPass1234#', 2);
        
        INSERT INTO mysql_query_rules (rule_id, active, match_digest,destination_hostgroup, apply) VALUES (100, 1, '^SELECT.*FOR UPDATE', 2, 1);
        
        INSERT INTO mysql_query_rules (rule_id, active, match_digest, destination_hostgroup, apply) VALUES (101, 1, '^SELECT', 3, 1);
      • LOAD/SAVE rules
      • run sysbench oltp, pointing to proxysql
      • wait X minutes for load
      • open PMM2 on app. navigate to ProxySQL Instance Summary
      • no matter which hostgroup you select, you always see the same data and many graphs not populated. see screenshots
      • this should not be related to pmm2 as none of the stats tables changed

        Attachments

        1. proxysql_1.png
          proxysql_1.png
          114 kB
        2. proxysql_2.png
          proxysql_2.png
          115 kB
        3. proxysql_3.png
          proxysql_3.png
          94 kB
        4. Screen Shot 2020-01-15 at 1.38.36 PM.png
          Screen Shot 2020-01-15 at 1.38.36 PM.png
          104 kB
        5. Screen Shot 2020-01-15 at 1.38.42 PM.png
          Screen Shot 2020-01-15 at 1.38.42 PM.png
          65 kB
        6. Screen Shot 2020-01-15 at 1.38.47 PM.png
          Screen Shot 2020-01-15 at 1.38.47 PM.png
          73 kB
        7. Screenshot 2021-02-10 at 16.29.09.png
          Screenshot 2021-02-10 at 16.29.09.png
          205 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              matthew.boehm@percona.com Matthew Boehm
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 hour
                  1h

                    Smart Checklist