Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Setting MySQL SlowLog Path #3194

Open
1 task done
Kindchooser opened this issue Sep 5, 2024 · 0 comments
Open
1 task done

Setting MySQL SlowLog Path #3194

Kindchooser opened this issue Sep 5, 2024 · 0 comments
Assignees
Labels
bug Bug report

Comments

@Kindchooser
Copy link

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
@Kindchooser Kindchooser added the bug Bug report label Sep 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Bug report
Projects
None yet
Development

No branches or pull requests

2 participants