Now that I’ve removed the monitors and rebuilt them, I see no data points in grafana for the centOS 6.8 system for mysql query stats despite setting innodb logging settings and a slow query log. QAN has data, but prometheus and graphana seem to not be getting anything.
# pmm-admin list
pmm-admin 1.0.7
PMM Server | 98.76.54.32:8080 (password-protected)
Client Name | centos68
Client Address | 12.34.56.78
Service Manager | unix-systemv
-------------- -------------------------------- ----------- -------- ------------------------------------------ ------------------------
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
-------------- -------------------------------- ----------- -------- ------------------------------------------ ------------------------
mysql:queries centos68 - YES admin:***@unix(/var/lib/mysql/mysql.sock) query_source=perfschema
linux:metrics centos68 42000 YES -
mysql:metrics centos68 42002 YES admin:***@unix(/var/lib/mysql/mysql.sock)
# pmm-admin check-network
PMM Network Status
Server Address | 98.76.54.32:8080
Client Address | 12.34.56.78
* System Time
Server | 2016-12-19 08:40:59 -0500 EST
Client | 2016-12-19 08:40:59 -0500 EST
Time Drift | OK
* Connection: Client --> Server
-------------------- -------
SERVER SERVICE STATUS
-------------------- -------
Consul API OK
Prometheus API OK
Query Analytics API OK
Connection duration | 67.923482ms
Request duration | 72.511934ms
Full round trip | 140.435416ms
* Connection: Client <-- Server
-------------- -------------------------------- --------------------- ------- ---------- ---------
SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD
-------------- -------------------------------- --------------------- ------- ---------- ---------
linux:metrics centos68 12.34.56.78:42000 OK YES YES
mysql:metrics centos68 12.34.56.78:42002 OK YES YES