Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PCX and PMM QAN WARNING qan-interval stat

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) 

 

How to test

None

How to document

None

Smart Checklist

Activity

Show:

Lalit Choudhary August 31, 2018 at 9:27 AM

There are no warnings when configuring monitoring with --query-source perfschema

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

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Needs Doc

Yes

Affects versions

Smart Checklist

Created August 31, 2018 at 8:54 AM
Updated November 13, 2024 at 8:43 AM

Flag notifications