by Pablo Padua | Apr 17, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at the mysqlpump utility. mysqlpump is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump...
by Dave Avery | Apr 13, 2017 | MySQL, Percona Live
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database...
by Tibor Korocz | Apr 12, 2017 | Insight for DBAs, MySQL
In this post, I am going to show you how you can minimize the performance impact of ProxySQL rules by using some finesse. Apply Test In my previous post, we could see the effect of the rules on ProxySQL performance. As we could also see, the “apply” option...
by marcos.albe | Apr 11, 2017 | Insight for DBAs, MySQL
As part of our support services, we do a lot of query optimization. This is where most performance gains come from. Here’s an example of the work we do. Some days ago a customer arrived with the following table: CREATE TABLE `infamous_table` ( `id` int(11) NOT...
by Tibor Korocz | Apr 10, 2017 | Benchmarks, MySQL, ProxySQL
In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL...
by Alexander Rubin | Apr 7, 2017 | Insight for DBAs, MySQL
In this blog, we’ll look at how queries in systems with parallel processing can return rows in a non-deterministic order (and how to fix it). Short story: Do not rely on the order of your rows if your query does not use ORDER BY. Even with ORDER BY, rows with...
by marcos.albe | Apr 6, 2017 | Insight for DBAs, Insight for Developers, MySQL
Updated 7-05-2019 In this blog, we’ll look at how to resolve MySQL error code 1215: “Cannot add foreign key constraint”. Our Support customers often come to us with things like “My database deployment fails with error 1215”, “Am...
by Alexey Stroganov | Apr 5, 2017 | Benchmarks, MySQL, Percona Software
In this blog post, we’ll look at some of the available PMP profiling tools. While debugging or analyzing issues with Percona Server for MySQL, we often need a quick understanding of what’s happening on the server. Percona experts frequently use the pt-pmp...
by Hrvoje Matijakovic | Apr 5, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server for MySQL 5.7.17-13 on April 5, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based...
by Dave Avery | Apr 4, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live, Webinars
Please join Percona’s CEO and Founder, Peter Zaitsev on April 6th, 2017 at 8:00 am PDT / 11:00 am EDT (UTC-7) as he presents Best Practices Migrating to Open Source Databases. Register Now This is a high-level webinar that covers the history of enterprise open source...
by Manjot Singh | Apr 4, 2017 | MongoDB, MySQL, Percona Live
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database...
by Michael Coburn | Apr 3, 2017 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Events, Percona Software
In honor of the upcoming MariaDB M17 conference in New York City on April 11-12, we have enhanced Percona Monitoring and Management (PMM) Metrics Monitor with a new MariaDB Dashboard and multiple new graphs! The Percona Monitoring and Management MariaDB Dashboard...
by Dave Avery | Mar 29, 2017 | MySQL, Webinars
Please join Percona’s Principal Technical Services Engineer Sveta Smirnova, and Senior Software Engineer George Lorch, MariaDB’s Query Optimizer Developer Sergei Petrunia and Facebook’s Database Engineer Yoshinori Matsunobu as they present MyRocks...
by Alexey Zhebel | Mar 27, 2017 | MySQL, Percona Events, Percona Software
Percona announces the availability of Percona Toolkit 3.0.2 on March 27, 2017. 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....
by Dave Avery | Mar 24, 2017 | MongoDB, MySQL, Percona Live
The Percona Live Open Source Database Conference 2017 in Santa Clara, California is just around the corner: April 24-27, 2017. We’re busy getting things ready to make sure everybody gets the most out of their time there. As part of that, we have some news and a couple...
by Hrvoje Matijakovic | Mar 24, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server for MySQL 5.7.17-12 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based...
by Hrvoje Matijakovic | Mar 24, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.35-81.0 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL...
by Dave Avery | Mar 23, 2017 | MySQL, Percona Live
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database...
by Dave Avery | Mar 13, 2017 | Cloud, Webinars
Join Percona’s Solutions Engineer Dimitri Vanoverbeke on Thursday, March 16, 2017 at 7:00 a.m. PDT / 10:00 a.m. EDT (UTC-7) for a webinar on Moving to Amazon Web Services (AWS). Register Now This webinar covers the many challenges faced when migrating applications...
by Sveta Smirnova | Mar 10, 2017 | MySQL, Security, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Access Privileges Issues webinar. First, I want to thank everybody for attending the February 23 webinar. The recording and slides for the webinar are available here. Below is the list...
