Tag - Monitoring

Tips for MySQL 5.7 Database Tuning and Performance

MySQL 5.7 Database Tuning

While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical […]

Read more

Advanced Query Analysis in Percona Monitoring and Management with Direct ClickHouse Access

query analysis clickhouse PMM

In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some queries, so here it goes.
PMM uses ClickHouse to store query performance […]

Read more

MySQL Performance Optimization with Percona Monitoring and Management – Webinar Followup

optimize MySQL with Percona Monitoring and Management

Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2).
There was a tremendous amount of interest and many more questions than I could answer, so I’m answering them in this blog post instead.
Q: What are the red and white dots on the last column in […]

Read more

Extending PMM’s Prometheus Configuration

Extending PMM Prometheus Configuration

Percona Monitoring and Management 2.4.0 (PMM), released several days ago, added support for custom extensions of the Prometheus configuration file. Before explaining what that is and how to use it, let me tell you a bit of history.
PMM 1.4.0, released 2.5 years ago, added support for hooking external Prometheus exporters into PMM’s Prometheus configuration […]

Read more

Webinar 4/1: Monitor High Traffic Events Using Percona Monitoring and Management

High Traffic Events Using Percona Monitoring and Management

Planning for your next high traffic event? If your databases need to be running at peak performance with no downtime – this webinar is for you.
Prepare for High Traffic Events (HTE) such as Black Friday, Cyber Monday, or any peak your organization manages. Learn how to monitor relevant KPIs and the best practices necessary […]

Read more