v2.13.0

Percona Monitoring and Management 2.13.0

Date:	December 29, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Release Highlights

1. Ability to monitor SSL-enabled MongoDB

   Allows PMM administrators to set up configured SSL certificate “keys” to authenticate the connection to PMM, specifically for setting up MongoDB. This is a critical security requirement especially in large enterprise infrastructure environments.

2. Technical Previews

   ⚠️ Caution
   We do not recommend the use of technical preview features in enterprise or production environments until the functionality is released as general availability (GA). While in Technical Preview status, these features are not supported by Percona Support SLA, except by Product/Engineering on a best-efforts basis.

   1. Integrated Alerting MVP

      A new feature in PMM to set up parameters and revive alerts about the Services and Nodes monitored by PMM.

      Read more on our blog and in our documentation.

   2. Node Summary/Nodes Overview dashboards: Show External services on dashboards

      Improves the user experience for adding and viewing external services on the Node Summary dashboard of PMM. External services means any data that can be monitored by a Prometheus exporter, for example, non-Percona supported databases like Redis, ElasticSearch, Cassandra, etc. or an organization’s external application.

   3. DBaaS Preview phase 1.0

      We are also releasing the first preview of DBaaS functionality; when combined with a compatible Kubernetes environment and Percona Operators, you can create Percona XtraDB or MongoDB clusters with just a few clicks. (Read more about configuration and usage.)

Improvements

• PMM-5364: Ability to monitor SSL-enabled MongoDB by passing certificate parameters in pmm-admin add command (Thanks to Hubertus Krogmann for reporting this issue)
• PMM-7086: Re-mapped /prometheus/<end-point> to /victoriametrics/<end-point> but created aliases for users that still rely on the /prometheus/<end-point> in bookmarks and scripts (Thanks to Daniel Guzman Burgos for reporting this issue)
• PMM-6713: Node Summary/Nodes Overview dashboards: External exporters can now be added to dashboard and shown as part of grouping of a broader service
• PMM-7173: VictoriaMetrics updated to 1.50.2: Includes HTML pages vs JSON output and new functions available for alerting rules (see all tags)

Bugs Fixed

• PMM-7054: ProxySQL Instance Summary dashboard: no Node Metrics
• PMM-7092: PMM Server Docker update from 2.11.1 to 2.12.0 leaves container in unhealthy state (Thanks to Hubertus Krogmann for reporting this issue)
• PMM-7208: Confusing "Access denied" message for 'Viewer' users on many dashboards
• PMM-6987: No IP address shown in log file of OVF appliance running in headless mode
• PMM-7146: MongoDB Instance Summary dashboard: ReplSet element showing metric name instead of replication set
• PMM-6992: Administrators can't see user's actual IP address in Grafana profile-Preferences-Sessions
• PMM-6865: Rendered dashboard images partly obscured by error message

v2.12.0

Percona Monitoring and Management 2.12.0

Date:	December 1, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Release Highlights

• VictoriaMetrics replaces Prometheus and is now the default data source. VictoriaMetrics supports both PUSH (client to server) and PULL metrics collection modes. (Read more.)
• PMM Client can be run as a Docker image.
• The 'Add Instance' page and forms have been redesigned and look much better.

New Features

• PMM-5799: PMM Client now available as docker image in addition to RPM, DEB and .tgz
• PMM-6968: Integrated Alerting: Basic notification channels actions API Create, Read, Update, Delete
• PMM-6842: VictoriaMetrics: Grafana dashboards to monitor VictoriaMetricsDB as replacement for dashboards that used to monitor Prometheus DB
• PMM-6395: Replace Prometheus with VictoriaMetrics in PMM for better performance and additional functionality

Improvements

• PMM-6744: Prevent timeout of low resolution metrics in MySQL instances with many tables (~1000's)
• PMM-6504: MySQL Replication Summary: MySQL Replication Delay graph not factoring in value of intentionally set SQL_Delay thus inflating time displayed
• PMM-6820: pmm-admin status --wait option added to allow for configurable delay in checking status of pmm-agent
• PMM-6710: pmm-admin: Allow user-specified custom 'group' name when adding external services
• PMM-6825: Allow user to specify 'listen address' to pmm-agent otherwise default to 127.0.0.1
• PMM-6793: Improve user experience of 'add remote instance' workflow
• PMM-6759: Enable Kubernetes startup probes to get status of pmm-agent using 'GET HTTP' verb
• PMM-6736: MongoDB Instance Summary dashboard: Ensure colors for ReplSet status matches those in MongoDB ReplSet Summary dashboard for better consistency
• PMM-6730: Node Overview/Summary Cleanup: Remove duplicate service type 'DB Service Connections'
• PMM-6542: PMM Add Instance: Redesign page for more intuitive experience when adding various instance types to monitoring
• PMM-6518: Update default data source name from 'Prometheus' to 'Metrics' to ensure graphs are populated correctly after upgrade to VictoriaMetrics
• PMM-6428: Query Analytics dashboard - Ensure user-selected filter selections are always visible even if they don't appear in top 5 results
• PMM-5020: PMM Add Remote Instance: User can specify 'Table Statistics Limit' for MySQL and AWS RDS MySQL to disable table stat metrics which can have an adverse impact on performance with too many tables

Bugs Fixed

• PMM-6811: MongoDB Cluster Summary: when secondary optime is newer than primary optime, lag incorrectly shows 136 years
• PMM-6650: Custom queries for MySQL 8 fail on 5.x (on update to pmm-agent 2.10) (Thanks to user debug for reporting this issue)
• PMM-6751: PXC/Galera dashboards: Empty service name with MySQL version < 5.6.40
• PMM-5823: PMM Server: Timeout when simultaneously generating and accessing logs via download or API
• PMM-4547: MongoDB dashboard replication lag count incorrect (Thanks to user vvol for reporting this issue)
• PMM-7057: MySQL Instances Overview: Many monitored instances (~250+) gives 'too long query' error
• PMM-6883: Query Analytics: 'Reset All' and 'Show Selected' filters behaving incorrectly
• PMM-6686: Query Analytics: Filters panel blank on Microsoft Edge 44.18362.449.0
• PMM-6007: PMM Server virtual appliance's IP address not shown in OVF console
• PMM-6754: Query Analytics: Bad alignment of percentage values in Filters panel
• PMM-6752: Query Analytics: Time interval not preserved when using filter panel dashboard shortcuts
• PMM-6664: Query Analytics: No horizontal scroll bar on Explain tab
• PMM-6632: Node Summary - Virtual Memory Utilization chart: incorrect formulas
• PMM-6537: MySQL InnoDB Details - Logging - Group Commit Batch Size: giving incorrect description
• PMM-6055: PMM Inventory - Services: 'Service Type' column empty when it should be 'External' for external services

Known Issues

• PMM-7092: Update docker pmm-server 2.11.1 to 2.12.0 results in an unhealthy container.

  Workaround: A folder is not created on container upgrade and will need to be created manually for one of the components. Before starting the new pmm-server 2.12.0, execute:  

  docker exec -ti pmm-server mkdir -p /srv/victoriametrics/data
  docker exec -ti pmm-server chown -R pmm:pmm /srv/victoriametrics/
  docker restart pmm-server

v2.11.1

Percona Monitoring and Management 2.11.1

Date:	October 19, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Bugs Fixed

• PMM-6782: High CPU usage after update to 2.11.0

v2.11.0

Percona Monitoring and Management 2.11.0

Date:	October 14, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

New Features

• PMM-6567: Technical preview of new PostgreSQL extension pg_stat_monitor
• PMM-6515: Link added directly to Node/Service page from Query Analytics filters, opens in new window

Improvements

• PMM-6727: Grafana plugin updates: grafana-polystat-panel=1.2.2, grafana-piechart-panel=1.6.1
• PMM-6625: Default sort to "Average - descending" on all dashboards
• PMM-6609: MySQL Instances Compare & Summary dashboards: Changed metric in 'MySQL Internal Memory Overview'
• PMM-6598: Dashboard image sharing (Share Panel): Improved wording with link to configuration instructions
• PMM-6557: Update Prometheus to 2.21.0
• PMM-6554: MySQL InnoDB Details dashboard: Add "sync flushing" to "InnoDB Flushing by Type"

Bugs Fixed

• PMM-4547: MongoDB dashboard replication lag count incorrect (Thanks to user vvol for reporting this issue)
• PMM-6639: Integrated update does not detect all container types
• PMM-6765: Tables information tab reports 'table not found' with new PostgreSQL extension pg_stat_monitor
• PMM-6764: Query Analytics: cannot filter items that are hidden - must use "Show all"
• PMM-6742: Upgrade via PMM UI stalls (on yum update pmm-update)
• PMM-6689: No PostgreSQL queries or metrics in Query Analytics with PostgreSQL 13 (postgresql_pgstatements_agent in Waiting status)
• PMM-6738: PostgreSQL examples shown despite --disable-queryexamples option
• PMM-6535: Unable to open 'Explore' in new window from Grafana menu
• PMM-6532: Click-through URLs lose time ranges when redirecting to other dashboards
• PMM-6531: Counter-intuitive coloring of element "Update Stats when Metadata Queried"
• PMM-6645: Clean up unnecessary errors in logs (vertamedia-clickhouse-datasource plugin)
• PMM-6547: Hexagonal graph tooltip text overflows bounding box

v2.10.1

Percona Monitoring and Management 2.10.1

Date:	September 22, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Bugs Fixed

• PMM-6643: New MongoDB exporter has higher CPU usage compared with old

v2.10.0

Percona Monitoring and Management 2.10.0

Date:	September 15, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

New Features

• PMM-2045: New dashboard: MySQL Group Replication Summary
• PMM-5738: Enhanced exporter: replaced original mongodb-exporter with a completely rewritten one with improved functionality
• PMM-5126: Query Analytics Dashboard: Search by query substring or dimension (Thanks to user debug for reporting this issue)
• PMM-6360: Grafana Upgrade to 7.1.3
• PMM-6355: Upgrade Prometheus to 2.19.3
• PMM-6597: Documentation: Updated Image rendering instructions for PMM
• PMM-6568: Reusable user interface component: Pop-up dialog. Allows for more consistent interfaces across PMM
• PMM-6375, PMM-6373, PMM-6372: Sign in, Sign up and Sign out UI for Percona Account inside PMM Server
• PMM-6328: Query Analytics Dashboard: Mouse-over crosshair shows value on sparklines
• PMM-3831: Node Summary Dashboard: Add pt-summary output to dashboard to provide details on system status and configuration

Improvements

• PMM-6647: MongoDB dashboards: RocksDB Details removed, MMAPv1 & Cluster Summary changed
• PMM-6536: Query Analytics Dashboard: Improved filter/time search message when no results
• PMM-6467: PMM Settings: User-friendly error message
• PMM-5947: Bind services to internal address for containers

Bugs Fixed

• PMM-6336: Suppress sensitive data: honor pmm-admin flag --disable-queryexamples when used in conjunction with --query-source=perfschema
• PMM-6244: MySQL InnoDB Details Dashboard: Inverted color scheme on "BP Write Buffering" panel
• PMM-6294: Query Analytics Dashboard doesn't resize well for some screen resolutions (Thanks to user debug for reporting this issue)
• PMM-5701: Home Dashboard: Incorrect metric for DB uptime (Thanks to user hubi_oediv for reporting this issue)
• PMM-6427: Query Analytics dashboard: Examples broken when switching from MongoDB to MySQL query
• PMM-5684: Use actual data from INFORMATION_SCHEMA vs relying on cached data (which can be 24 hrs old by default)
• PMM-6500: PMM Database Checks: Unwanted high-contrast styling
• PMM-6440: MongoDB ReplSet Summary Dashboard: Primary shows more lag than replicas
• PMM-6436: Query Analytics Dashboard: Styles updated to conform with upgrade to Grafana 7.x
• PMM-6415: Node Summary Dashboard: Redirection to database's Instance Summary dashboard omits Service Name
• PMM-6324: Query Analytics Dashboard: Showing stale data while fetching updated data for query details section
• PMM-6316: Query Analytics Dashboard: Inconsistent scrollbar styles
• PMM-6276: PMM Inventory: Long lists unclear; poor contrast & column headings scroll out of view
• PMM-6529: Query Analytics filter input margin disappears after scrolling

Known Issues

• PMM-6643: High CPU usage for new MongoDB exporter (fixed in Percona Monitoring and Management 2.10.1)

v2.9.1

Percona Monitoring and Management 2.9.1

Date:	August 4, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Improvements

• PMM-6230: Custom dashboards set as Home remain so after update
• PMM-6300: Query Analytics Dashboard: Column sorting arrows made easier to use (Thanks to user debug for reporting this issue)
• PMM-6208: Security Threat Tool: Temporarily silence viewed but un-actioned alerts
• PMM-6315: Query Analytics Dashboard: Improved metrics names and descriptions
• PMM-6274: MySQL User Details Dashboard: View selected user's queries in Query Analytics Dashboard
• PMM-6266: Query Analytics Dashboard: Pagination device menu lists 25, 50 or 100 items per page
• PMM-6262: PostgreSQL Instance Summary Dashboard: Descriptions for all 'Temp Files' views
• PMM-6253: Query Analytics Dashboard: Improved SQL formatting in Examples panel
• PMM-6211: Query Analytics Dashboard: Loading activity spinner added to Example, Explain and Tables tabs
• PMM-6162: Consistent sort order in dashboard drop-down filter lists
• PMM-5132: Better message when filter search returns nothing

Bugs Fixed

• PMM-5783: Bulk failure of SHOW ALL SLAVES STATUS scraping on PS/MySQL distributions triggers errors
• PMM-6294: Query Analytics Dashboard doesn't resize well for some screen resolutions (Thanks to user debug for reporting this issue)
• PMM-6420: Wrong version in successful update pop-up window
• PMM-6319: Query Analytics Dashboard: Query scrolls out of view when selected
• PMM-6302: Query Analytics Dashboard: Unnecessary EXPLAIN requests
• PMM-6256: Query Analytics Dashboard: InvalidNamespace EXPLAIN error with some MongoDB queries
• PMM-6329: Query Analytics Dashboard: Unclear origin of sparkline tool-tip on mouse-over
• PMM-6259: Query Analytics Dashboard: Slow appearance of query time distribution graph for some queries
• PMM-6189: Disk Details Dashboard: Disk IO Size chart larger by factor of 512
• PMM-6269: Query Analytics Dashboard: Metrics drop-down list obscured when opened
• PMM-6247: Query Analytics Dashboard: Overview table not resizing on window size change
• PMM-6227: Home Dashboard redirection to Node Summary Dashboard not working

v2.9.0

Percona Monitoring and Management 2.9.0

Date:	July 14, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Release Highlights

This release brings a major rework of the Query Analytics (QAN) component, completing the migration from Angular to React, and adding new UI functionality and features.

For details, see:

• PMM-5125: Implement new version of QAN
• PMM-5516: QAN migration to React and new UI implementation

You can read more in the accompanying blog post (here).

New Features

• PMM-6124: New dashboards: MongoDB Replica Set Summary and MongoDB Cluster Summary
• PMM-1027: New dashboard: MySQL User Details (INFORMATION_SCHEMA.CLIENT_STATISTICS)
• PMM-5604: User interface for MongoDB EXPLAIN
• PMM-5563: Per-Service and per-Node Annotations (This completes the work on improvements to the Annotation functionality.)

Improvements

• PMM-6114: Sort Agents, Nodes, and Services alphabetically by name in Inventory page (Thanks to user debug for reporting this issue)
• PMM-6147: Update Grafana plugins to latest versions

Bugs Fixed

• PMM-5800: QAN explain and tables tabs not working after removing MySQL metrics agent
• PMM-5812: Prometheus relabeling broken (relabel_configs un-marshal errors) (Thanks to user b4bufr1k for reporting this issue)
• PMM-6184: MongoDB Instances Compare dashboard shows MySQL metric
• PMM-5941: Stacked Incoming/Outgoing Network Traffic graphs in MySQL Instances Overview dashboard prevents comparison
• PMM-6194: Missing UID for Advanced Data Exploration dashboard
• PMM-6191: Incorrect computation for Prometheus Process CPU Usage panel values in Prometheus dashboard
• PMM-6175: Node Overview dashboard shows unit for unit-less value ‘Top I/O Load’

v2.8.0

Percona Monitoring and Management 2.8.0

Date:	June 25, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL
performance.

Improvements

• PMM-544: Agents, Services and Nodes can now be removed via the ‘PMM Inventory’ page
• PMM-5706: User-installed Grafana plugins unaffected by PMM upgrade

Bugs Fixed

• PMM-6153: PMM 2.7.0 inoperable when no Internet connectivity
• PMM-5365: Client fails to send non-UTF-8 query analytics content to server (Thanks to user romulus for reporting this issue)
• PMM-5920: Incorrect metric used in formula for “Top Users by Rows Fetched/Read” graph
• PMM-6084: Annotations not showing consistently on dashboards
• PMM-6011: No data in MongoDB Cluster summary, RocksDB & MMAPv1 details
• PMM-5987: Incorrect total value for virtual memory utilization

v2.7.0

Percona Monitoring and Management 2.7.0

Date:	June 9, 2020
Installation:	Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

In this release, we have updated Grafana to version 6.7.4 to fix CVE-2020-13379. We recommend updating to the latest version of PMM as soon as possible.

New Features

• PMM-5257, PMM-5256, & PMM-5243: pmm-admin socket option (–-socket) to specify UNIX socket path for connecting to MongoDB, PostgreSQL, and ProxySQL instances

Improvements

• PMM-2244: pmm-admin status command output shows both pmm-admin and pmm-agent versions
• PMM-5968: Disallow PMM Server node or agent removal via API
• PMM-5946: MySQL Table Details dashboard filter on Service Name prevents display of services without data
• PMM-5926: Expose PMM agent version in pmm-admin status command
• PMM-5891: PMM Home page now includes News panel
• PMM-5906: Independent update of PMM components deactivated

Bugs Fixed

• PMM-6004: MySQL exporter reporting wrong values for cluster status (wsrep_cluster_status)
• PMM-4547: MongoDB dashboard replication lag count incorrect
• PMM-5524: Prometheus alerting rule changes needs docker restart to activate
• PMM-5949: Unwanted filters applied when moving from QAN to Add Instance page
• PMM-5870: MySQL Table Details dashboard not showing separate service names for tables
• PMM-5839: PostgreSQL metrics disparity between query time and block read/write time
• PMM-5348: Inventory page has inaccessible tabs that need reload to access
• PMM-5348: Incorrect access control vulnerability fix (CVE-2020-13379) by upgrading Grafana to 6.7.4