Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1453

MySQLD Exporter wrong mapping of innodb_buffer_pool_pages

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.8.0
    • Component/s: MySQLd_Exporter
    • Labels:
    • Story Points:
      1

      Description

      Related SHOW GLOBAL STATUS OUTPUT

      mysql> show global status like "innodb_buffer_pool_pages%";
      -------------------------------------------------+
      Variable_name	Value
      -------------------------------------------------+
      Innodb_buffer_pool_pages_data	3132830
      Innodb_buffer_pool_pages_dirty	240035
      Innodb_buffer_pool_pages_flushed	8093972
      Innodb_buffer_pool_pages_free	8006
      Innodb_buffer_pool_pages_LRU_flushed	0
      Innodb_buffer_pool_pages_made_not_young	14479053
      Innodb_buffer_pool_pages_made_young	2227681
      Innodb_buffer_pool_pages_misc	135564
      Innodb_buffer_pool_pages_old	1156329
      Innodb_buffer_pool_pages_total	3276400
      -------------------------------------------------+
      10 rows in set (0.00 sec)

       

      This mixes in one both the STATS of the buffer pool (ie free, total, old etc) and the CHANGES ie flushed, made_yong etc

      The Exporter does NOT currently handle it correctly trying to split it to groups:

      # HELP mysql_global_status_buffer_pool_page_changes_total Innodb buffer pool page state changes.
      # TYPE mysql_global_status_buffer_pool_page_changes_total counter
      mysql_global_status_buffer_pool_page_changes_total{operation="flushed"} 7.82024699e+08
      mysql_global_status_buffer_pool_page_changes_total{operation="lru_flushed"} 0
      mysql_global_status_buffer_pool_page_changes_total{operation="made_not_young"} 2.8624479e+09
      mysql_global_status_buffer_pool_page_changes_total{operation="made_young"} 2.13379735e+08
      mysql_global_status_buffer_pool_page_changes_total{operation="old"} 183904
      mysql_global_status_buffer_pool_page_changes_total{operation="total"} 524224
      # HELP mysql_global_status_buffer_pool_pages Innodb buffer pool pages by state.
      # TYPE mysql_global_status_buffer_pool_pages gauge
      mysql_global_status_buffer_pool_pages{state="data"} 498344
      mysql_global_status_buffer_pool_pages{state="dirty"} 220047
      mysql_global_status_buffer_pool_pages{state="free"} 8085
      mysql_global_status_buffer_pool_pages{state="misc"} 17795
      

      The "changes" group includes the TOTAL and OLD which need to be in the second group as it is "state" and not operation


      Peter Zaitsev, CEO, Percona
      Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev

      Tasks

      1. Move the following out of mysql_global_status_buffer_pool_page_changes_total into mysql_global_status_buffer_pool_pages:
        mysql_global_status_buffer_pool_page_changes_total{operation="old"}
        mysql_global_status_buffer_pool_page_changes_total{operation="total"}

        to:

        mysql_global_status_buffer_pool_pages{state="old"}
        mysql_global_status_buffer_pool_pages{state="total"}
        
      2. Update relevant graphs with the new syntax of the metrics (consider grep against MySQL graphs)

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  pz Peter Zaitsev
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 6 hours
                    6h