EmergencyEMERGENCY? Get 24/7 Help Now!

MyRocks Engine: Things to Know Before You Start

 | February 1, 2018 |  Posted In: MySQL

MyRocks

Percona recently released Percona Server with MyRocks as GA. You can see how Facebook explains wins they see in production with MyRocks. Now if you use Percona repositories, you can simply install MyRocks plugin and enable it with ps-admin –enable-rocksdb. There are some major and minor differences when comparing it to typical InnoDB deployments, and […]

Read More

Percona Monitoring and Management 1.7.0 (PMM) Is Now Available

 | January 31, 2018 |  Posted In: Events and Announcements, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL

Experimental Percona Monitoring and Management

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

Read More

Aurora Hash Join Optimization (with a Gentle Reminder on Lab Features)

 | January 31, 2018 |  Posted In: Amazon Aurora, AWS, Cloud and MySQL, Insight for DBAs, MySQL

Aurora Hash Join Lab Mode

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

Read More

MySQL Query Performance: Not Just Indexes

 | January 30, 2018 |  Posted In: Insight for DBAs, MySQL

MySQL Query Performance

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

Read More

Percona XtraDB Cluster 5.7.20-29.24 Is Now Available

 | January 26, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

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

Read More

Percona Monitoring and Management (PMM) 1.6.1 Is Now Available

 | January 25, 2018 |  Posted In: Events and Announcements, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL

Experimental Percona Monitoring and Management

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. Bug fixes 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, […]

Read More

Percona XtraDB Cluster 5.6.38-26.23 Is Now Available

 | January 24, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

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

Read More