Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 1.13.0
    • Fix Version/s: None
    • Component/s: PMM Client
    • Labels:

      Description

      Configured PMM monitoring for PXC cluster node.

      Getting warning every second in qan-agent log for slow query log

      2018/08/31 14:07:00.788304 WARNING qan-interval stat /var/lib/mysql/node1-slow.log: no such file or directory
      2018/08/31 14:08:00.686834 WARNING qan-interval stat /var/lib/mysql/node1-slow.log: no such file or directory
      2018/08/31 14:09:00.756747 WARNING qan-interval stat /var/lib/mysql/node1-slow.log: no such file or directory

      slow query log exists in the specified directory:

      [root@node1 mysql]# ls -l /var/lib/mysql/node1-slow.log
      rw-r----. 1 mysql mysql 426273 Aug 30 19:47 /var/lib/mysql/node1-slow.log

       

      Steps to reproduce :

      • Have PXC setup with the following configuration for pm monitoring as PMM_DOC
      log_output=file
      slow_query_log=ON
      long_query_time=0 
      log_slow_rate_limit=100
      log_slow_rate_type=query
      log_slow_verbosity=full
      log_slow_admin_statements=ON
      log_slow_slave_statements=ON
      slow_query_log_always_write_time=1
      slow_query_log_use_global_control=all
      innodb_monitor_enable=all 
      userstat=1
      

       

      Adding monitoring:

      pmm-admin add mysql --host=192.168.1.111 --user=remote --password=Admin@123 --port=3306 --query-source  slowlog
      
      

      pmm user privileges on server*:*

      mysql> show grants for 'pmm'@'%';
      ------------------------------------------------------------------------------

      Grants for pmm@%

      ------------------------------------------------------------------------------

      GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON . TO 'pmm'@'%'
      GRANT UPDATE, DELETE, DROP ON `performance_schema`.* TO 'pmm'@'%'

      ------------------------------------------------------------------------------
      2 rows in set (0.00 sec) 

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lalit.choudhary Lalit Choudhary
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: