Percona announces the release of Percona Monitoring and Management 1.7.0. (PMM ) 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 […]Read more
The Aurora hash join feature for relational databases has been around for a while now. But unlike MySQL Block Nested Loop algorithm, an Aurora hash join only caters to a specific number of use cases. When implemented with the optimizer properly, they can provide great benefits with certain workloads. Below we’ll see a brief […]Read more
Percona announces the release of Percona Server for MySQL 5.5.59-38.11 on January 30, 2018. Based on MySQL 5.5.59, including all the bug fixes in it, Percona Server for MySQL 5.5.59-38.11 is now the current stable release in the 5.5 series.
Percona Server for MySQL is open-source and free. Downloads are available here and from the Percona Software […]
In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t).
As we look at MySQL query performance, our first concern is often whether a query is using the right indexes to retrieve the data. This is based on the assumption that finding the data is […]
In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance.
About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been one of my favorite features in the MySQL 5.7 release. The reason is simple: […]
Percona announces the release of Percona XtraDB Cluster 5.7.20-29.24 (PXC) on January 26, 2018. Binaries are available from the downloads section or our software repositories.
NOTE: Due to new package dependency,
Ubuntu/Debian users should use apt-get dist-upgrade, apt upgrade, or apt-get install percona-xtradb-cluster-57 to upgrade.
Percona XtraDB Cluster 5.7.20-29.24 is now the current release, based on the […]
This Week in Data with Colin Charles 25: Meltdown/Spectre still dominate, FOSDEM approaches and Timescale gets funding
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Still on Meltdown/Spectre, this time MariaDB Corporation has published Meltdown Vulnerability Impact On MariaDB Server – interesting the comparison between glibc/tcmalloc. Worthy Facebook thread about this too, with a bit of chat about MongoDB performance. […]
In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature.
One great new feature introduced in MySQL 8.0 that – from my point of view – requires attention is RESOURCE_GROUP.
Short disclaimer: I want to point out that MySQL 8.0 is not GA yet, so it is possible for the MySQL 8.0 RESOURCE_GROUP […]
Percona announces the release of Percona Monitoring and Management 1.6.1. This release contains fixes to bugs found after Percona Monitoring and Management 1.6.0 was released.
PMM-1660: QAN for MongoDB would not display data when authentication was enabled.
PMM-1822: In Metrics Monitor, some tag names were incorrect in dashboards.
PMM-1832: After upgrading to 1.5.2, it was not […]
Percona announces the release of Percona XtraDB Cluster 5.6.38-26.23 (PXC) on January 24, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.38-26.23 is now the current release, based on the following:
Percona Server for MySQL 5.6.38
Galera/Codership WSREP API Release 5.6.38
Galera Replication library 3.21
All Percona software is open-source and free.
Fixed […]Read more