Tag - Percona Software

Beware of Unstable Query Digests in MySQL

Unstable Query Digests in MySQL

If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table.
You might assume these hashes are stable between different versions, so, for example, when upgrading from MySQL 5.7 to MySQL 8, you can compare the query response time and other execution […]

Read more

New Feature in Percona Backup for MongoDB, Fixes for PMM: Release Roundup 1/20/2020

Percona Releases Jan 20

It’s release roundup time here at Percona!
In our continued effort to make it a little easier for you to keep track of our latest releases and updates, every few weeks a Release Roundup showcases the latest in software updates, tools, and features to help you manage and deploy our software, with highlights and critical […]

Read more

Group Replication in Percona Server for MySQL

group replication percona server mysql

Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations.
For this I planned to use three bare metal nodes, SSD drives, and a 10Gb network available for in-between nodes […]

Read more

Using Flame Graphs to Process Outputs From pt-pmp

flame graphs pt-tmp

In a previous post Profiling Software Using perf and Flame Graphs, we took a look at how to generate Flame Graphs from perf outputs. In this short follow-up, we will use Flame Graphs to process outputs from pt-pmp. Flame Graphs were not originally thought of for this purpose, but since pt-pmp outputs are similar […]

Read more

Changing the Default Admin Password in Docker-Based Deployment of PMM2

default password pmm2

If you’re automating Percona Monitoring and Management 2 (PMM) deployment with docker, you may want to set a different admin user password upon installation instead of being required to change it upon first login. Here is how you can do it:
After following the PMM2 Docker Installation Instructions, you can run this command:

Shell

docker exec -t […]

Read more