Skip to content
logo
Percona Distribution for MySQL
Measurement and monitoring
Initializing search
    /percona/pdmysql-docs
    /percona/pdmysql-docs
    • Home
      • Components
      • Deployment variants
      • Install Percona Distribution for MySQL
      • Upgrade Percona Distribution for MySQL
      • Downgrade Percona Distribution for MySQL
      • Technical overview
      • Architecture and components
      • Measurement and monitoring
      • Deployment
      • Replication manager for Percona XtraDB Cluster
      • Replication manager troubleshooting
      • Single replica manager for Percona XtraDB Cluster
      • Uninstalling Percona Distribution for MySQL
      • Release notes index
      • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL (2023-03-20)
      • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster (2023-03-15)
      • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL Update (2023-02-15)
      • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL (2023-02-09)
      • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster Update (2023-01-23)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Second Update (2023-01-23)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Update (2023-01-06)
      • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster (2022-12-28)
      • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster Update (2022-12-01)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL (2022-11-29)
      • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster (2022-09-12)
      • Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)
      • Percona Distribution for MySQL 8.0.28 using Percona XtraDB Cluster (2022-07-19)
      • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL Update (2022-06-20)
      • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL (2022-05-12)
      • Percona Distribution for MySQL 8.0.27 using Percona XtraDB Cluster (2022-04-11)
      • Percona Distribution for MySQL 8.0.27 using Percona Server for MySQL (2022-03-03)
      • Percona Distribution for MySQL 8.0.26 using Percona XtraDB Cluster (2022-01-17)
      • Percona Distribution for MySQL 8.0.26 using Percona Server for MySQL (2021-10-20)
      • Percona Distribution for MySQL 8.0.25 using Percona XtraDB Cluster (2021-11-22)
      • Percona Distribution for MySQL 8.0.25 using Percona Server for MySQL (2021-07-13)
      • Percona Distribution for MySQL 8.0.23 using *Percona XtraDB Cluster* Update (2021-09-15)
      • Percona Distribution for MySQL 8.0.23 using Percona XtraDB Cluster (2021-06-09)
      • Percona Distribution for MySQL 8.0.23 using Percona Server for MySQL (2021-05-12)
      • Percona Distribution for MySQL 8.0.22 using Percona XtraDB Cluster (2021-03-22)
      • Percona Distribution for MySQL 8.0.22 using Percona Server for MySQL (2020-12-14)
      • Percona Distribution for MySQL 8.0.21 using Percona XtraDB Cluster (2020-12-28)
      • Percona Distribution for MySQL 8.0.21 using Percona Server for MySQL (2020-10-13)
      • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Second Update (2020-10-22)
      • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Update (2020-10-09)
      • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster (2020-10-01)
      • Percona Distribution for MySQL 8.0.20 using Percona Server for MySQL (2020-07-21)
      • Percona Distribution for MySQL 8.0.19 (2020-06-22)
      • Copyright and Licensing Information
      • Trademark Policy
      • Glossary

    Measurement and monitoring¶

    To ensure that database infrastructure is performing as intended or at its best, specific metrics need to be measured and alerts are to be raised when some of these metrics are not in line with expectations. A periodic review of these measurements is also encouraged to promote stability and understand potential risks associated with the database infrastructure.

    The following are the 3 aspects of database performance measurement and monitoring:

    • Measurement - To understand how a database infrastructure is performing, multiple aspects of the infrastructure need to be measured. With measurement it’s important to understand the impact of the sample sizes, sample timing, and sample types.

    • Metrics - Metrics refer to the actual parts of the database infrastructure being measured. When we discuss metrics, more isn’t always better as it could introduce unintentional noise or make troubleshooting overly burdensome.

    • Alerting - When one or many metrics of the database infrastructure is not within a normal or acceptable range, an alert should be generated so that the team responsible for the appropriate portion of the database infrastructure can investigate and remedy it.

    Monitoring and measurement for this solution are covered by Percona Monitoring and Management. It has a specific dashboard to monitor the Group Replication state and cluster status as a whole. For more information, read Percona Monitoring and Management Documentation.

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2023-03-20
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.