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
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 […]
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 […]
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 […]
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 […]