Buy Percona ServicesBuy Now!

ProxySQL Firewalling

 | January 15, 2018 |  Posted In: Database Monitoring, MySQL, ProxySQL, Security

ProxySQL Firewalling

In this blog post, we’ll look at ProxySQL firewalling (how to use ProxySQL as a firewall). Not long ago we had an internal discussion about security, and how to enforce a stricter set of rules to prevent malicious acts and block other undesired queries. ProxySQL came up as a possible tool that could help us in achieving […]

Read More

Compare Current and Past Time Series Graphs in Percona Monitoring and Management (PMM)

 | January 12, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management

Percona Monitoring and Management

In this short blog post, I will show you how you can compare current and past time series in Percona Monitoring and Management (PMM). Recently, a support customer shared a graph with us that compared query throughput between today and yesterday as a confirmation that optimizing their server variables improved performance. Do you want to […]

Read More

Case in Point: A Year of Customer Experience with Percona

 | January 3, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, High-availability, MySQL, Percona Managed Services, Percona Monitoring and Management, Percona MySQL Consulting, Percona MySQL Support, Percona Remote DBA, Percona Support

Customer Experience

In 2017 we have welcomed many new customers into the Percona fold. It’s always interesting to find out what challenges the Percona team helped them to address and how they chose their relationship with Percona. As unbiased champions of open source database software, our consultancy, support and managed services staff apply their expertise across a […]

Read More

Percona Monitoring and Management 1.5: QAN in Grafana Interface

 | December 1, 2017 |  Posted In: Database Monitoring, MongoDB, MySQL, Percona Monitoring and Management

Percona-Monitoring-and-Management-1.5-QAN-1 small

In this post, we’ll examine how we’ve improved the GUI layout for Percona Monitoring and Management 1.5 by moving the Query Analytics (QAN) functions into the Grafana interface. For Percona Monitoring and Management users, you might notice that QAN appears a little differently in our 1.5 release. We’ve taken steps to unify the PMM interface […]

Read More

MySQL Dashboard Improvements in Percona Monitoring and Management 1.4.0

 | October 31, 2017 |  Posted In: Database Monitoring, InnoDB, MySQL, Percona Monitoring and Management

In this blog post, I’ll walk through some of the improvements to the Percona Monitoring and Management (PMM) MySQL dashboard in release 1.4.0. As the part of Percona Monitoring and Management development, we’re constantly looking for better ways to visualize information and help you to spot and resolve problems faster. We’ve made some updates to the […]

Read More

JSON Output of the pmm-admin list Command

 | October 25, 2017 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management

In this blog post, we’ll look at Percona Monitoring and Management’s pmm-admin list command. The pmm-admin list command shows all monitoring services you have added using the pmm-admin add command. Starting with version 1.4.0, Percona Monitoring and Management (PMM) also lists external monitoring services when you run pmm-admin list, i.e., those services that monitor the backends not supported out of the box (such as PostgreSQL databases). […]

Read More

Graph Descriptions for Metrics Monitor in Percona Monitoring and Management 1.3.0

 | October 5, 2017 |  Posted In: Database Monitoring, MariaDB, MongoDB, MySQL, Percona Monitoring and Management

PMM 1.3.0

The Metrics Monitor of Percona Monitoring and Management 1.3.0 (PMM) provides graph descriptions to display more information about the monitored data without cluttering the interface. Percona Monitoring and Management 1.3.0 is a free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance. You can run PMM in your own environment for maximum security and […]

Read More

Big Dataset: All Reddit Comments – Analyzing with ClickHouse

 | October 2, 2017 |  Posted In: Database Monitoring, MongoDB, MySQL, MySQL 8.0, PostgreSQL, Yandex ClickHouse

ClickHouse

In this blog, I’ll use ClickHouse and Tabix to look at a new very large dataset for research. It is hard to come across interesting datasets, especially a big one (and by big I mean one billion rows or more). Before, I’ve used on-time airline performance available from BUREAU OF TRANSPORTATION STATISTICS. Another recent example is NYC […]

Read More

Percona Monitoring and Management 1.3.0 Query Analytics Support for MongoDB

 | September 28, 2017 |  Posted In: Database Monitoring, MongoDB, Percona Monitoring and Management

Percona Monitoring and Management 1.3.0

Percona is pleased to announce the General Availability of Query Analytics (QAN) from Percona Monitoring and Management 1.3.0 (PMM). This new release introduces the support of MongoDB. In general, the purpose of QAN is to help detect queries that consume the most amount of time inside of your database server. It provides detailed real-time analysis of […]

Read More

sysbench Histograms: A Helpful Feature Often Overlooked

 | September 20, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL

Sysbench Histograms

In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time […]

Read More