by Jervin Real | Jan 31, 2018 | Cloud, Insight for DBAs, MySQL
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...
by Hrvoje Matijakovic | Jan 30, 2018 | MySQL, Percona Events, Percona Software
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...
by Peter Zaitsev | Jan 30, 2018 | Insight for DBAs, MySQL
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...
by Alexander Rubin | Jan 29, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance. Introduction About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been...
by Dmitriy Kostiuk | Jan 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
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,...
by Colin Charles | Jan 26, 2018 | Cloud, MongoDB, MySQL, Percona Events, Percona Live, Percona Software, PostgreSQL, ProxySQL
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...
by Alex Poritskiy | Jan 25, 2018 | Insight for DBAs, MySQL, Open Source
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...
by Borys Belinsky | Jan 25, 2018 | MySQL, Percona Events, Percona Software
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....
by Dmitriy Kostiuk | Jan 24, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
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:...
by Ceri Williams | Jan 24, 2018 | Insight for DBAs, MySQL, Security
The news that the latest MySQL 8.0.4 RC (release candidate) is available is indeed exciting. Unfortunately for users of the auth_socket plugin, dangers lie in wait! Back in November 2015, I reported Failure of auth_socket authentication with sha256_password as...
by Sveta Smirnova | Jan 24, 2018 | Insight for DBAs, Insight for Developers, MySQL, Open Source, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Troubleshooting MySQL Crashes on January 25, 2018, at 10:00 am PST (UTC -8) / 1:00 pm EST (UTC -5). Register Now This webinar is for every MySQL user! In this talk, I won’t focus...
by Vadim Tkachenko | Jan 23, 2018 | Insight for DBAs, Insight for Developers, MySQL, Security
In this blog post, we’ll look at the performance hit from the Spectre bug fix on Ubuntu. Recently we measured the performance penalty from the Meltdown fix on Ubuntu servers. It turned out to be negligible. Today, Ubuntu made a Spectre bug fix on Ubuntu...
by Hrvoje Matijakovic | Jan 23, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Open Source, Percona Events, Percona Software
Percona is pleased to announce the release of Percona Server for MongoDB 3.6.1-1.0beta on January 23, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. NOTE: This version is considered BETA quality, and is not intended...
by Colin Charles | Jan 22, 2018 | Insight for DBAs, MariaDB, MySQL, Open Source, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents Differences Between MariaDB and MySQL on Wednesday, January 24, 2018, at 7:00 am PST (UTC -8) / 10:00 am EST (UTC -5). Register Now Tags: MariaDB, MySQL, Percona Server for MySQL, DBA, SysAdmin, DevOps...
by Borys Belinsky | Jan 19, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management (PMM) 1.6.0. In this release, Percona Monitoring and Management Grafana metrics are available in the Advanced Data Exploration dashboard. We’ve improved the integration with MyRocks, and its data...
by Colin Charles | Jan 19, 2018 | MongoDB, MySQL, Percona Events, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There is still much going on when it comes to Meltdown/Spectre in our world. Percona’s Vadim Tkachenko and Alexey...
by Vadim Tkachenko | Jan 18, 2018 | Insight for DBAs, Insight for Developers, MySQL, Security
In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects MySQL...
by Dmitriy Kostiuk | Jan 18, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.4, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Peter Zaitsev | Jan 17, 2018 | Insight for DBAs, Monitoring, Percona Software
In this blog post, I’ll look at some helpful tips on troubleshooting Percona Monitoring and Management metrics. With any luck, Percona Monitoring and Management (PMM) works for you out of the box. Sometimes, however, things go awry and you see empty or broken...
by Jervin Real | Jan 16, 2018 | Insight for DBAs, MySQL
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the second of two parts. In the first part of this post, we described the high-level overview of implementing incremental refresh on a ClickHouse table as an alternative support...
