Skip to content

Instantly share code, notes, and snippets.

@jraddaoui
Created December 9, 2019 16:57
Show Gist options
  • Save jraddaoui/760748cf52cb4bc043a679b22917d079 to your computer and use it in GitHub Desktop.
Save jraddaoui/760748cf52cb4bc043a679b22917d079 to your computer and use it in GitHub Desktop.
AtoM PMM using slow query log
---
version: "2"
services:
percona:
volumes:
- ./etc/mysql/pmm.cnf:/etc/my.cnf.d/pmm.cnf:ro
pmm_server:
image: percona/pmm-server
ports:
- "127.0.0.1:63006:80"
environment:
- SERVER_USER=pmm
- SERVER_PASSWORD=pmm
pmm_client:
image: perconalab/pmm-client
restart: on-failure:5
user: root
volumes:
- percona_data:/var/lib/mysql:rw
environment:
- PMM_SERVER=pmm_server
- PMM_USER=pmm
- PMM_PASSWORD=pmm
- DB_TYPE=mysql
- DB_HOST=percona
- DB_PORT=3306
- DB_USER=root
- DB_PASSWORD=my-secret-pw
[mysqld]
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
# performance_schema_instrument='%=on'
innodb_monitor_enable=all
userstat=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment