by Borys Belinsky | Jan 4, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.6 on January 4, 2018. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona...
by Lorraine Pocklington, Community Manager | Jan 3, 2018 | Cloud, Insight for DBAs, Monitoring, MySQL, Percona Services, Percona Software
In 2017 we have welcomed many new customers into the Percona fold. It’s always interesting to find out what challenges the Percona team helped them to address and how they chose their relationship with Percona. As unbiased champions of open source database software,...
by David Ducos | Jan 2, 2018 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
In this post, we’ll look at how to improve queries using generated columns and ProxySQL instead of implementing a referenced table. Developers and architects don’t always have the time or complete information to properly analyze and design a database. That is...
by Dave Avery | Dec 29, 2017 | Benchmarks, MariaDB, MongoDB, MySQL
Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open...
by Colin Charles | Dec 22, 2017 | MySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I think the biggest news from last week was from cPanel – if you haven’t already read the post, please do – on Being a...
by Colin Charles | Dec 20, 2017 | Cloud, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Percona is extending the Percona Live 2018 call for papers deadline to January 12, 2018! Percona’s gift to you this holiday season is the gift of time – submit your speaking topics right up until January 12, 2018! As the year winds up, we received many requests...
by Krunal Bauskar | Dec 19, 2017 | Insight for DBAs, MySQL, Percona Software, Webinars
In this blog, we will answer questions from our webinar on Percona XtraDB Cluster 101. Recently (7 Dec 2017) I presented a webinar about Percona XtraDB Cluster 101. Firstly, thanks to all the attendees: we had a great webinar with quite some interesting questions and...
by Borys Belinsky | Dec 18, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.5.3. This release contains fixes for bugs found after the release of Percona Monitoring and Management 1.5.2, as well as some important fixes and improvements not related to the previous release....
by Dave Avery | Dec 13, 2017 | Cloud, MongoDB, MySQL, Percona Live
Get your Percona Live Open Source Database Conference 2018 Super Saver tickets now. The countdown is on for the annual Percona Live Open Source Database Conference 2018! The conference takes place in Santa Clara, CA from April 23-25, 2018. The theme is Championing...
by Roel Van de Paar | Dec 12, 2017 | Insight for DBAs, MySQL, Percona Software
Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC. On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate. I tested the MySQL...
by Colin Charles | Dec 11, 2017 | Insight for DBAs, MariaDB, MongoDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents 2017 Year in Review for Open Source Database Software on Wednesday, December 13, 2017 at 7:00 am PST / 10:00 am EST (UTC-8). Register Here 2017 is soon coming to an end, and it’s good to pause and...
by Yves Trudeau | Dec 7, 2017 | Hardware and Storage, Insight for DBAs, MySQL, Percona Software
This post is a hands-on look at ZFS with MySQL. In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a...
by Krunal Bauskar | Dec 6, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Software Engineer (PXC Lead), Krunal Bauskar as he presents Percona XtraDB Cluster 101 on Thursday, December 7, 2017, at 7:00 am PST / 10:00 am EST (UTC-8). Tags: Percona XtraDB Cluster, MySQL, High Availability, Clustering Experience Level: Beginner...
by Vadim Tkachenko | Dec 5, 2017 | Insight for DBAs, MySQL
In this post, we’ll briefly look at window functions in MySQL 8.0. One of the major features coming to MySQL 8.0 is the support of Window functions. The detailed documentation is already available here Window functions. I wanted to take a quick look at the cases...
by Michael Coburn | Dec 1, 2017 | MongoDB, Monitoring, MySQL, Percona Software
In this post, we’ll examine how we’ve improved the GUI layout for Percona Monitoring and Management 1.5 by moving the Query Analytics (QAN) functions into the Grafana interface. For Percona Monitoring and Management users, you might notice that QAN appears...
by Borys Belinsky | Nov 29, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.5.1. This release contains fixes for bugs found after Percona Monitoring and Management 1.5.0 was released. Bug fixes PMM-1771: When upgrading PMM to 1.5.0 using Docker commands, PMM System...
by Borys Belinsky | Nov 28, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.5.0 on November 28, 2017. This release focuses on the following features: Enhanced support for MySQL on Amazon RDS and Amazon Aurora – Dedicated Amazon Aurora dashboard offers maximum visibility into...
by Colin Charles | Nov 22, 2017 | Insight for DBAs, MariaDB, MySQL
In this blog post, we’ll look at a solving Sudoku using MySQL 8.0 recursive common table expression. Vadim was recently having a little Saturday morning fun solving Sudoku using MySQL 8. The whole idea comes from SQLite, where Richard Hipp has come up with some...
by Colin Charles | Nov 13, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December 22, 2017. Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open...
by Peter Zaitsev | Nov 9, 2017 | MySQL
In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment. You might have heard many times about the importance of looking at the number of context switches to indicate if MySQL is...
