some graph show "No data points"

Percona Monitoring and Management (PMM) PMM 1.x
1

Hi

I have question.

some graph show “No data points”

pmm server 1.2.0
pmm client 1.2.0

monitoring db server

mysql 5.6.35 community
mysql 5.6.35 enterprise

Dashboard : MySQL Performance Schema

No data points graph

Index Access Operations(Load)

Table Access Operations(Load)

Dashboard : MySQL InnoDB Metrics

No data points graph

InnoDB Checkpoint Age

InnoDb Change Buffer

How i can solve this problem?

2

can you check if everything is configured according to recommendations?
[url]Percona Monitoring and Management

if the issue still exists after reconfiguration please give me know, I will try to reproduce.

3

my server setting capture upload.

do i need other setting?

photoid=49038

4

Hi next1009 ,

can you run the following query and share output?

SELECT OBJECT_SCHEMA, OBJECT_NAME, ifnull(INDEX_NAME, 'NONE') as INDEX_NAME,
COUNT_FETCH, COUNT_INSERT, COUNT_UPDATE, COUNT_DELETE,
SUM_TIMER_FETCH, SUM_TIMER_INSERT, SUM_TIMER_UPDATE, SUM_TIMER_DELETE
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE OBJECT_SCHEMA NOT IN ('mysql', 'performance_schema')

the query is taken from mysqld_exporter - [url]mysqld_exporter/perf_schema_index_io_waits.go at main · prometheus/mysqld_exporter · GitHub

5

hi.

ouput img uploaded.

thanks for your help

photoid=49126
photoid=49126939×680 70.4 KB

6

interesting, raw data for Index “Access Operations (Load)” exists in the database (we just fetched it by query above).
so let’s check if mysqld_exporter can fetch it.

can you share the output of the following command?

docker exec -it pmm-server curl --insecure https://CLIENT-IP:42002/metrics-lr | grep mysql_perf_schema_index_io_waits_seconds_total

it is needed to run on PMM Server side

also please measure response time.

docker exec -it pmm-server bash -c 'time curl --insecure https://CLIENT-IP:42002/metrics-hr >/dev/null'
7

i’m capture img uploaded.

  1. first code is nothing happen.

% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:–:-- --:–:-- --:–:-- 0
100 94033 100 94033 0 0 405k 0 --:–:-- --:–:-- --:–:-- 404k

real 0m0.235s
user 0m0.066s
sys 0m0.089s

photoid=49130
photoid=49130986×155 25.8 KB

8

I think you have file.
please check

it is true, it is possible to get such result in two cases: [LIST=1]
[]during command --disable-tablestats option was specified.
[]your database has more that 1000 tables and pmm-admin disabled per table statistics collection.
[/LIST]

9

Ok. I understand.

Dashboard : MySQL Performance Schema

No data points graph

Index Access Operations(Load)

Table Access Operations(Load)

data is not collected because --disable-tablestats or more 1000 tables.

However…

Why is this graph “no data points graph” ?

Dashboard : MySQL InnoDB Metrics

No data points graph

InnoDB Checkpoint Age

InnoDb Change Buffer

10

Hi next1009 ,

“InnoDB Checkpoint Age” graph use variables which are added only to Percona Server “SHOW ENGINE INNODB STATUS” output.
see “Extended Show Engine InnoDB Status” page – [url]https://www.percona.com/doc/percona-server/LATEST/diagnostics/innodb_show_status.html[/url]
also it is possible to get these variables if you use XtraDB engine for MariaDB.

the same story for variables from “InnoDB Change Buffer” graph.

anyway, this information should be explained in graph description. So I created ticket PMM-1233, feel free to add any comments directly into it.

11

@Mykola

thank you for your help