Name: #Percona Monitoring and Management 2 - Improved Query Analytics
Uploaded: 2019-10-16T03:21:52.000Z
Duration: 1 min 34 s
Description: Percona Monitoring and Management 2 - Improved Query Analytics

Customer Success Management Training

Help Desk

Web and Video Conferencing

Customer Support

Continuous Integration

Development

Business Intelligence (BI)

Collaboration

Environmental, Social, and Governance (ESG)

Payment Facilitation

VoIP

Enterprise

Accounting

Payment Gateway

Finance and Accounting

Applicant Tracking

Corporate Learning Management

Course Authoring

HR Management

Payroll

Professional Employer Organizations (PEO)

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

AI Governance

Access Gateways

Cloud Storage

Disaster Recovery as a Service (DRaaS)

Fraud Detection

Graph Database

High Availability Cluster

Infrastructure-as-Code (IaC)

Infrastructure-as-a-Service

Integration Platform as a Service (iPaaS)

Network Behavior Analysis

Network Performance Monitoring

SOA Application Gateways

SaaS Management

Secure Email Gateway

System Monitoring

Traffic Switching

Value-Added Resellers (VARs)

Virtualization Management

Information Technology

A/B Testing

Ad Serving & Retargeting

All-in-One Marketing

Audience Engagement

Content Management

Content Marketing

Customer Reference Management

Data Management

Email Marketing

Gamification

Marketing Automation

Mobile Marketing

SMS Marketing

Social Media Management

Survey & Forms Building

Video Streaming

Web Analytics

Marketing

Project Management

Professional Services

Customer Relationship Management (CRM)

Sales Gamification

Social Commerce

Sales

Architecture

Commercial Drone

Equation Editors

Home Health Care

Insurance Agency Management

Membership Management

OSS/BSS (Operations Support/Business Support)

Online Voting

Practice Management

Revenue Cycle Management (RCM)

Simulation

Text Analysis

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

Zabbix

Oracle Enterprise Manager

Oracle

Dynatrace

Dynatrace LLC

New Relic

Datadog

ClusterControl

Severalnines AB

pganalyze

Foglight

Quest Software

LogicMonitor

Redgate Monitor

Redgate

MySQL

PostgreSQL

MariaDB Platform

Redis Software

Grafana

Prometheus

MongoDB

Amazon Aurora

Amazon Relational Database Service (RDS)

### Database Performance Monitoring
Users generally praise Percona Monitoring and Management (PMM) for its robust database performance monitoring capabilities. Reviewers consistently highlight PMM's ability to effectively monitor database performance, enabling them to identify and address performance issues proactively. The tool's features such as query analytics, time-based analysis, and alerting mechanisms are commended for their contribution to optimizing database performance and ensuring smooth operations. Additionally, users appreciate PMM's user-friendly interface and the depth of insights it provides into database internals, allowing for comprehensive monitoring and analysis of system performance. (Source Reviews: [1](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-23-08-20-08), [2](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-09-10-17-00), [3](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-08-09-28-25), [4](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2021-05-11-15-25-12), [5](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-22-12-14-12), [6](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-11-20-18-13-39), [7](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-06-04-47-20))

### Query Optimization
User feedback on Percona Monitoring and Management (PMM)'s query optimization features varies widely. Some users praise PMM for its ability to identify and address performance issues in database queries efficiently. They appreciate the Query Analyzer tool for helping them pinpoint problematic and resource-intensive queries, enabling faster issue resolution. On the other hand, there are users who express a desire for more documentation to aid less experienced MySQL users in understanding the data presented by PMM's query optimization functionalities. Despite differing opinions, it is evident that PMM plays a significant role in enhancing query performance and overall database management for many users. (Source Reviews: [1](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-23-08-20-08), [2](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-09-10-17-00), [3](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2021-05-11-15-25-12), [4](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-08-09-28-25), [5](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-22-12-14-12))

### Database Internals and Architecture
Users generally praise Percona Monitoring and Management (PMM) for its robust database internals and architecture capabilities. Reviewers consistently highlight PMM's ability to provide deep insights into MySQL internal graphs, detailed graphs of database internals, and system performance. The Query Analyzer tool is particularly lauded for its effectiveness in identifying problematic or resource-intensive queries, enhancing the overall database management experience. Additionally, users appreciate PMM's user-friendly interface and the ease of monitoring hundreds or thousands of MySQL database servers in a centralized manner. (Source Reviews: [1](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-23-08-20-08), [2](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-11-20-18-13-39), [3](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-06-04-47-20), [4](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-08-09-28-25))

### Customization and Configuration
Reviewers generally praise Percona Monitoring and Management (PMM)'s customization and configuration features. Users appreciate the ability to customize alert thresholds based on their specific needs, such as setting warning and critical levels for CPU usage. The platform offers a range of customization options, allowing users to tailor their monitoring dashboards to suit their preferences and cover various company requirements. Some reviewers suggest improvements in the notification system for more customization options, indicating a desire for further enhancements in this area. Despite some minor suggestions for improvement, overall sentiment leans towards positive feedback regarding the customization and configuration capabilities of Percona Monitoring and Management (PMM). (Source Reviews: [1](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-23-08-20-08), [2](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2021-05-11-15-25-12), [3](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-11-20-18-13-39), [4](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-06-04-47-20), [5](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-09-10-17-00), [6](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-08-09-28-25))

### Dashboards and Visualization
Users generally appreciate the comprehensive dashboards and visualization features offered by Percona Monitoring and Management (PMM). Reviewers highlight the ease of customization and the depth of metrics provided for MySQL, DBaaS, and ProxySQL. The integration with tools like Prometheus and the REST API for Grafana dashboards are also noted as advantageous. However, some users express concerns about setting up alerts and suggest improvements for better scaling in larger deployments. Despite minor drawbacks, the overall sentiment leans towards positive regarding PMM's dashboards and visualization capabilities. (Source Reviews: [1](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-23-08-20-08), [2](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-22-12-14-12), [3](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-06-04-47-20), [4](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-11-20-18-13-39), [5](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2021-05-11-15-25-12), [6](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-08-09-28-25), [7](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-09-10-17-00))

### Deployment and Usability
Users consistently highlight Percona Monitoring and Management (PMM)'s deployment process as straightforward and efficient, allowing for quick implementation across various database servers. The platform's usability features, such as customizable dashboards and detailed metrics, contribute to an enhanced user experience by providing valuable insights into query performance and system health. Additionally, the integration with tools like Prometheus and Grafana further enhances the usability of PMM, making it a valuable asset for monitoring and optimizing database performance. (Source Reviews: [1](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-10-08-09-28-25), [2](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-12-09-10-17-00), [3](https://www.trustradius.com/reviews/percona-monitoring-and-management-pmm-2020-11-20-18-13-39))

In-Depth Metrics: Many users have praised the tool for providing in-depth metrics for MySQL, DBaaS, and ProxySQL. They appreciate being able to monitor their databases in the cloud and optimize performance with ease.

Customizable and Deployable: Users have found it easy to customize and deploy the tool according to their specific needs. This flexibility allows them to tailor the monitoring experience to their database environment, ensuring efficient tracking of queries' time and performance.

Comprehensive Features: The tool has garnered positive feedback from reviewers for its wide range of features. With functionalities like live support, alerting, tracking, communication dashboard, and more, users feel equipped with all the necessary tools for effective database management.

Percona Monitoring and Management (PMM) is a highly sophisticated open-source solution that helps businesses manage their database environments effectively. It simplifies the overall management process, reduces complexity and optimizes performance by quickly identifying issues that may impact business operations. PMM has innovative tools which improve data security, reduce the risk of exposure and prevent potential outages in your database systems.

This software's primary objective is to provide users with a single platform to efficiently monitor databases' health status, including troubleshooting bottlenecks and scaling issues without vendor lock-in or exorbitant fees. It seamlessly integrates both on-premises and cloud-based databases into one centralized location for easy access. Thousands of companies worldwide trust PMM to ensure that their complex database environments are functioning smoothly while maintaining high levels of security standards. Percona's team provides customers with enterprise-class software, support, consulting services along with training options from seasoned professionals who operate globally in more than 35 countries worldwide.

Standard

Professional

Standard (subcription)

Professional (subscription)

Enterprise (subscription)

dbForge Studio (Edge)

Amazon RDS Performance Insights

Percona Monitoring and Management (PMM)

Database Performance Monitoring software is designed to monitor the database at all times to monitor current state or past state, monitor Top SQL operations (designed to limit data query to e.g. top 3 to ensure that performance is not compromised), event calendar and Disk Space. All relevant data is visible on a single management dashboard.

Database Performance Monitoring

Percona Monitoring and Management Demonstration

Percona Monitoring and Management Demo

#PMM Overview | about Percona Monitoring and Management

Percona Monitoring and Management PMM Demo 35 - Platform Teams - 2022-05-31

Installing Percona Monitoring & Management PMM on Ubuntu 20.04 LTS - Database Monitoring Tutorial

Likelihood to Recommend

Usability

Support Rating

Percona is a market leader in providing best-of-breed enterprise-class software, support, consulting, managed services, and training for on-premise and cloud-based open-source databases. Percona was founded on the belief that everyone should have access to scalable, secure, efficient, and resilient database software features, without inflated fees or vendor lock-in. Our global network of experts spans more than 35 countries and we have assisted over 3,000 clients worldwide.

Percona

Percona Monitoring and Management 2 - Improved Query Analytics

#Percona Monitoring and Management 2 - Improved Query Analytics

#Percona Monitoring and Management (PMM) is a single pane of glass for managing and monitoring the performance of your #MySQL, #MariaDB, #PostgreSQL, and #MongoDB #databases.

Created to support #OpenSource #DBAs and developers, #Percona Monitoring and Management (PMM) allows deep insight into the performance of applications and databases.

In this video, we break down the improved query analytics feature of #PMM that allow visualization queries for fleets of servers, sorting by any column, or from multiple dimensions.

Additionally, new query analytics for #PostgreSQL allows you to visualize query performance for #PostgreSQL servers alongside #MySQL and #MongoDB.



You can find more about #Percona Monitoring and Management in this link 👇🏻👇🏻👇🏻
https:/www.percona.com/pmm to download today!

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel 

Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: https://twitter.com/Percona
Follow Percona on Facebook: https://www.facebook.com/Percona
Follow Percona on Instagram: https://www.instagram.com/percona_llc/
Follow Percona on LinkedIn: https://www.linkedin.com/company/percona/

SurveyMonkey

BlackLine

Avast Small Business Cybersecurity Solutions

Senior Business Controller

Percona Monitoring and Management (PMM) 2021-05-11 15:25:12

SolarWinds Database Performance Monitor

Percona XtraDB Cluster

Percona XtraBackup

Percona Server for MySQL

AWS Educate core team member

Percona Monitoring and Management (PMM) 2020-11-20 18:13:39

Software Engineer && Security researcher

Percona Monitoring and Management (PMM) 2020-12-09 10:17:00

Senior Database Architect

Percona Monitoring and Management (PMM) 2020-10-08 09:28:25

Nagios Core

Percona Backup for MongoDB

Senior Engineering Manager (Site Reliability Engineering)

Percona Monitoring and Management (PMM) 2020-10-06 04:47:20

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Number of servers

Time to load

System requirements

Not intuitive

Fine tuning

Alerting system

Add support

High availability

Top notch

Monitoring tools

Easy to use

Time based

Easy to deploy

Knowledge base

Active community

Working perfectly

Nice interface

Excellent support

Community support

Set up

Home

Database Performance Monitoring Tools

The most prominent thing is that [Percona Monitoring and Management (PMM)] has greatly
reduced much of the complexities by simplifying management. It has made
deployment very easy for us. It keeps on adding new features in order to bring
ease for the users. There is the availability of many unique features that makes my
work easier for me. I am having a very positive experience with this software because it is playing a great role in my department. In
my opinion, this tool is enriched with maximum features for effective management
of monitoring of MySQL.

It serves us in the best ways. It has given us a golden opportunity to deeply looking at time-based analysis in order to make sure whether the data system is working perfectly or not.
It can be set up straightforwardly without any hurdle. It always gives a smooth performance with much accuracy. It keeps on making innovations by adding new features as well as default dashboards for meeting all of our needs.
The most impressive thing about this tool is that it consists of a huge number of incomparable features such as the Live supporting feature, Alerting feature, tracking, communication dashboard, and many other beneficial features too.

Sometimes it creates problems while serving a huge number of servers but I am sure its efficient team will overcome this problem soon and with its rapid advancements there will surely be more latest and advanced alerting options.
Truly speaking this is a great invention with very few shortcomings. I never face any dependency issues.

Query and cache details.
MySQL connections chart.
Customization of automation features.
Client thread estimator.

This is a matchless tool for keeping us alert with all amazing monitoring capabilities. Almost all of its features and functionalities help us in achieving our goals by enhancing success rates.
Customer support is responsible.
Its performance is mind-blowing.

BlackLine, SurveyMonkey, Zoom, Avast Business Antivirus

Percona Monitoring and Management has helped in monitoring thousand of database servers "MySQL" in one place which has decreased the complexity of our system. I like to do an Advanced Configuration, there is more option available to customize. I think the most valuable and secure features are the warning critical levels. For example, in one case we were looking to alert of CPU usage - and if it's over 60% in an average period of time then it's not entrusting, and if it's over 90% it's critical, which you can specify the values that are best for your application. It's easy to use and deploy with a Beautiful GUI with Grafana and has Zabbix integration.

Everything has its graphs by category
Easy enough to customized and deploy
Very in depth metrics for MySQL, DBaaS, ProxySQL

PMM alerting system should be updated and improved
In some categories you cant grasp 25% of information

Great for MYSQL Insights
Database internals Alerts
Its helps to give in depth view to Dev and DBA

Datadog and SolarWinds Database Performance Monitor (formerly VividCortex)

Percona XtraBackup, Percona XtraDB Cluster, Percona Server for MySQL

Percona Monitoring and Management (PMM) offers us a very complete view of everything that happens, allowing us to select the time intervals we want to study and individually select the database we want to see, thus improving the user experience.
"Metrics Monitor" &amp; "Query Analitycs" are two interesting functionalities that allow us to detect problems in the performance of our queries, in addition to providing proactive information on possible performance problems in the future if what it shows us reaches the production teams with those that interact with our clients or the administrators of our company. The set of graphics and elements to select gives us great ease when configuring the dashboard to our liking and covering many of the company's needs.

Measure the time and performance of queries made in a database
Integration with tools like Prometheus with the aim of storing information based on time
Monitor our databases in the cloud, as well as optimize the performance of the database, improving the usability of customer applications

It would be interesting to add support to more monitoring tools and improve the notification system so that there are more customization options.

Percona Server for MySQL, Percona Server for MongoDB, MySQL

We monitor hundreds of database servers (MySQL) with PMM and we has been actively using it on prod since the first betas. It's extremely helpful, easy to deploy and it makes possible for the whole OPS team to check the status of the DB layer. The Query Analyzer is the only Open Source query visualization tool that is being developed and it's also useful when hunting for problematic/resource intensive queries.

Easy to deploy.
Easy to use.
Nice interface.

Setting up alerts is still complicated.
Automatic dashboards based on ec2 tags.
Better scaling for larger deployment.