percona/pmm

Setting MySQL SlowLog Path

Opened this issue · 0 comments

Kindchooser commented

Description

environment
Host: Windows, with MySQL installed
Docker: Installed PMM Server and PMM Client images separately
edition:
Windows：(23H2 22631.2861)
Mysql：8.0
PMM-Server：2.42.0
PMM-Client：2.42.0

When setting the slow logging metric for MySQL for PMM Client, the log path always includes the datapath path of my.ini, and when PMM Client reads files, it uses the Linux path

I tried Docker to mount the directory, but still skipped it and only read the slow log path in my.ini

docker run command:
docker run --rm --name pmm-client --user root -e PMM_AGENT_SERVER_ADDRESS=192.168.100.132 -e PMM_AGENT_SERVER_USERNAME=admin -e PMM_AGENT_SERVER_PASSWORD=admin -e PMM_AGENT_SERVER_INSECURE_TLS=1 -e PMM_AGENT_SETUP=1 -e PMM_AGENT_CONFIG_FILE=config/pmm-agent.yaml -v "C:\ProgramData\MySQL\MySQL Server 8.0\Data":/var/lib/mysql percona/pmm-client:2

log

Expected Results

Allow specifying the slow query log path, especially when the host is MySQL and the pmm client is Linux

Actual Results

Unable to read slow query logs

Version

PMM-Server：2.42.0
PMM-Client：2.42.0

Steps to reproduce

No response

Relevant logs

2024-09-05 17:12:03 time="2024-09-05T09:12:03.050+00:00" level=error msg="Failed to start reader for file C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data\\/DESKTOP-GB8DM03-slow.log: open C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data\\/DESKTOP-GB8DM03-slow.log: no such file or directory." agentID=/agent_id/10d97fce-b35a-40f2-a929-a5605913805c component=agent-builtin type=qan_mysql_slowlog_agent

Code of Conduct

  • I agree to follow Percona Community Code of Conduct