by Borys Belinsky | Jan 31, 2018 | MySQL, Percona Events, Percona Software
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...
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 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 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 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 Michael Coburn | Jan 16, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona...
by Dave Avery | Jan 15, 2018 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live
Take a look at the sneak peek of the breakout sessions for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, California. Early Bird registration discounts are available until...
by Agustín | Jan 11, 2018 | Insight for DBAs, MySQL
In this short blogpost, we’ll show you how to use the mysql_random_data_load tool to insert random data into tables. This is a great aide in testing when you have empty tables and need them to be populated with data. We’ve all done it manually (the INSERT...
by Alexander Rubin | Jan 10, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll provide an explanation of why you should avoid using the CREATE TABLE AS SELECT statement. The SQL statement “create table <table_name> as select …” is used to create a normal or temporary table and materialize the...
by Jervin Real | Jan 9, 2018 | Insight for DBAs, MySQL
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the first of two parts. You can see Part 2 of this post here. ClickHouse is fast Blazing fast! It’s quite easy to pick up, and with ProxySQL integrating with existing...
by Peter Zaitsev | Jan 9, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Basic Tags: Developer, DBAs, Operations, Executive, MySQL There are many great...
by Peter Zaitsev | Jan 8, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads. I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks storage...
by Peter Zaitsev | Jan 5, 2018 | MySQL, Webinars
Thank you for attending my webinar on Wednesday, December 20, 2017, InnoDB Performance Optimization. In this blog, I will provide answers to the Q & A for the webinar. Are the T2 CPUs similar to the M4 series? I would expect them to be similar. Amazon does not...
