QAN MySQL Slowlog Agent status UNKNOWN

Percona Monitoring and Management (PMM) Database Monitoring and Management
1

Hi,
I have installed PMM Server and register client succesfully. Through the percona web UI and from command line, looks like all is running well except Slowlog Agent state is UNKNOWN.

image
image1714×345 20.5 KB

PMM Server : Docker , version 2.36
PMM Client : Self Host Ubuntu 18.04
Database : MariaDB 10.1.48

Appreciate any suggest for troubleshoot it.

2

@Fandi_Ivon,
Please provide the exact commands you used to configure the command-line client. Also, have you enabled the slow query log in MariaDB?

3

Hi @matthewb ,
Thanks for response.
I have follow this guidance

  1. Slow Log ON

    image
    image726×227 5.33 KB

  2. Below is my exact command to connect QAN Agent

pmm-admin add mysql --query-source=slowlog --size-slow-logs=1GiB --username=user --password=password PPID 192.168.33.138:3306

Is there any step that I missed ?

4

That looks correct. What about long_query_time MySQL parameter?
Can you tail -f /var/log/mysql/mariadb-slow.log and see new queries being added?

5

  1. Variable long_query_time = 0
    image

  2. tail -f /var/log/mysql/mariadb-slow.log output is empty. I try cat command also empty.

6

After restart mysql service, now here is output from tail command

image
image1600×430 21.9 KB

Slowlog Agent status still UNKNOWN

7

Are you seeing queries in PMM now? Have you looked at permissions between the user running pmm-agent vs the slow query log?

8

I didn’t see queries in PMM. Not even my registered node appear in QAN menu yet.
What command to see permissions between the user running pmm-agent vs the slow query log?

9

ps and ls are typically used to look at permissions of running processes and files.