Buy Percona ServicesBuy Now!

Webinar Thursday Aug 9: Migrating to AWS Aurora, Monitoring AWS Aurora with PMM

 | August 9, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MySQL, Percona Monitoring and Management, PMM, Technical Webinars

Monitoring Amazon Aurora with PMM

Please join Autodesk’s Senior Database Engineer, Vineet Khanna, and Percona’s Sr. MySQL DBA, Tate McDaniel as they present Migrating to Aurora and Monitoring with PMM on Thursday, August 9th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now Amazon Web Services (AWS) Aurora is one of the most popular cloud-based RDBMS […]

Read More

How to Change Settings for PMM Deployed via Docker

 | August 9, 2018 |  Posted In: Containers, Docker, MySQL, Percona Monitoring and Management, PMM

change settings for PMM deployed docker

When deployed through Docker Percona Monitoring and Management (PMM) uses environment variables for its configuration For example, if you want to adjust metrics resolution you can pass -e METRICS_RESOLUTION=Ns  as  an option to the docker run  command:

You would think if you want to change the setting for existing installation you can just stop the container with docker stop  and […]

Read More

Resource Usage Improvements in Percona Monitoring and Management 1.13

 | August 7, 2018 |  Posted In: Benchmarks, Insight for DBAs, MongoDB, MySQL, Percona Monitoring and Management, PMM

PMM 1-13 reduction CPU usage by 5x

In Percona Monitoring and Management (PMM) 1.13 we have adopted Prometheus 2, and with this comes a dramatic improvement in resource usage, along with performance improvements! What does it mean for you? This means you can have a significantly larger number of servers and database instances monitored by the same PMM installation. Or you can […]

Read More

Webinar Tues 8/14: Utilizing ProxySQL for Connection Pooling in PHP

 | August 6, 2018 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, PMM, ProxySQL, Technical Webinars

ProxySQL for connection pooling

Please join Percona’s Architect, Tibi Köröcz as he presents Utilizing ProxySQL for Connection Pooling in PHP on Tuesday August 14, 2018, at 8:00 am PDT (UTC-7) / 11:00 am EDT (UTC-4).   Register Now ProxySQL is a very powerful tool, with extended capabilities. This presentation will demonstrate how to use ProxySQL to gain functionality (seamless […]

Read More

Percona Monitoring and Management 1.13.0 Is Now Available

 | August 1, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

Percona Monitoring and Management

PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. The most significant feature in this release is Prometheus 2, however we also packed a […]

Read More

When Database Warm Up is Not Really UP

 | July 10, 2018 |  Posted In: InnoDB, MySQL, Percona Monitoring and Management, PMM

first few minutes MySQL Warm Up graph from PMM

The common wisdom with database performance management is that a “cold” database server has poor performance. Then, as it “warms up”, performance improves until finally you reach a completely warmed up state with peak database performance. In other words, that to get peak performance from MySQL you need to wait for database warm up. This […]

Read More

Configuring PMM Monitoring for MongoDB Cluster

 | July 5, 2018 |  Posted In: MongoDB, Percona Monitoring and Management, PMM

In this blog, we will see how to configure Percona Monitoring and Management (PMM) monitoring for a MongoDB cluster. It’s very simple, like adding a replica set or standalone instances to PMM Monitoring.  For this example, I have used docker to create PMM Server and MongoDB sharded cluster containers. If you want the steps I used […]

Read More

Percona Monitoring and Management 1.12.0 Is Now Available

 | June 27, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

Percona Monitoring and Management

PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. In release 1.12, we invested our efforts in the following areas: Visual Explain in […]

Read More

MongoDB Explain – Using PMM-QAN for MongoDB Query Analytics

 | June 26, 2018 |  Posted In: .PMM QAN, EXPLAIN, MongoDB, Percona Monitoring and Management, PMM

MongoDB explain plan with PMM-QAN

In this blog post, we will walk through PMM-Query Analytics for MongoDB. We will see how to analyze MongoDB query performance; review the initial parameters that we need to check; and find out how to compare MongoDB query performance with and without indexes with the help of EXPLAIN plan. The Percona Monitoring and Management QAN (PMM-QAN) dashboard […]

Read More

Webinar Weds 20/6: Percona XtraDB Cluster 5.7 Tutorial Part 2

 | June 19, 2018 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, PMM, ProxySQL, Technical Webinars

webinar Percona XtraDB Cluster

Including setting up Percona XtraDB Cluster with ProxySQL and PMM Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial Part 2 on Wednesday, June 20th, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Register Now   Never used Percona XtraDB Cluster before? This is the webinar for […]

Read More