Not the answer you need?
Register and ask your own question!

some graph show "No data points"

next1009next1009 ContributorCurrent User Role Contributor
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?

Comments

  • MykolaMykola Percona Percona Staff Role
    can you check if everything is configured according to recommendations?
    https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html

    if the issue still exists after reconfiguration please give me know, I will try to reproduce.
  • next1009next1009 Contributor Current User Role Contributor
    my server setting capture upload.

    do i need other setting?
  • MykolaMykola Percona Percona Staff Role
    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 - https://github.com/prometheus/mysqld_exporter/blob/master/collector/perf_schema_index_io_waits.go#L12-L16
  • next1009next1009 Contributor Current User Role Contributor
    hi.

    ouput img uploaded.

    thanks for your help
  • MykolaMykola Percona Percona Staff Role
    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'
    
  • next1009next1009 Contributor Current User Role Contributor
    i'm capture img uploaded.


    1. first code is nothing happen.


    2.
    % 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
  • MykolaMykola Percona Percona Staff Role
    I think you have file.
    please check

    it is true, it is possible to get such result in two cases:
    1. during command --disable-tablestats option was specified.
    2. your database has more that 1000 tables and pmm-admin disabled per table statistics collection.
  • next1009next1009 Contributor Current User Role Contributor
    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
  • MykolaMykola Percona Percona Staff Role
    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 -- https://www.percona.com/doc/percona-server/LATEST/diagnostics/innodb_show_status.html
    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.
  • next1009next1009 Contributor Current User Role Contributor
    @Mykola

    thank you for your help
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.