EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Monitoring Plugins 1.1.8 Release Is Now Available

 | February 5, 2018 |  Posted In: Events and Announcements, MongoDB, MySQL, Percona Monitoring Plugins

Percona Monitoring Plugins 1.1.7

Percona announces the release of Percona Monitoring Plugins 1.1.8. Changelog Add MySQL 5.7 support Changed a canary check to use timestamp.now() and return a timedelta.seconds Remove an additional condition for the Dictionary memory allocated Fixed a false-positive problem when the calculated delay was less than 0 and the -m was not set. Fixed the problem where slaves […]

Read More

This Week in Data with Colin Charles 26: Percona Live Schedule is Near Completion, FOSDEM Underway and a Percona Toolkit Use Case

 | February 2, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Orchestrator, Percona Live, Percona Server for MySQL, PostgreSQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 update: tutorials have been picked, and the schedule/press release should be announced by next week. We’ve (the committee) rated over 300+ talks, and easily 70% of the schedule should go […]

Read More

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

Percona Server for MySQL 5.5.59-38.11 is Now Available

 | January 30, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona Server for MySQL 5.6

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

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