by Colin Charles | Apr 12, 2017 | MariaDB, Percona Live
At Percona, we support MariaDB Server (in addition to MySQL, Percona Server for MySQL, MongoDB and Percona Server for MongoDB, of course!), and that is reflected in the good, high-quality technical content about MariaDB Server at the Percona Live Open Source 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 Dave Avery | Apr 11, 2017 | MySQL, Webinars
Please join Percona’s Senior Technical Operations Architect Tim Vaillancourt as he presents Tuning MongoDB Consistency on April 12, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now Welcome to part two of Percona’s tuning series. In our previous webinar,...
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 Marco Tusa | Apr 10, 2017 | Insight for DBAs, MySQL, Percona Software
If you met one of the (few) MySQL consultants around the globe and asked him/her to review your queries and/or schemas, I am sure that he/she would tell you something regarding the importance of good primary key(s) design. Especially in the case of InnoDB, I’m...
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 Alexey Zhebel | Apr 7, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.3-1.3 on April 6, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.4.3-1.3 Percona Server for MongoDB 3.4.3-1.3 is...
by Dave Avery | Apr 6, 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 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 Alexey Zhebel | Apr 3, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.1.2 on April 3, 2017. For installation instructions, see the Deployment Guide. This release includes several new dashboards in Metrics Monitor, updated versions of software components used in PMM...
by Alexey Stroganov | Mar 30, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at the performance of SST data transfer using encryption. In my previous post, we reviewed SST data transfer in an unsecured environment. Now let’s take a closer look at a setup with encrypted network connections between the...
by Alexey Stroganov | Mar 29, 2017 | Insight for DBAs, MySQL
In this blog, we’ll look at evaluating the performance of an SST data transfer without encryption. A State Snapshot Transfer (SST) operation is an important part of Percona XtraDB Cluster. It’s used to provision the joining node with all the necessary...
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 Sveta Smirnova | Mar 28, 2017 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting Issues with MySQL Character Sets webinar. First, I want to thank everybody for attending the March 9 MySQL character sets troubleshooting webinar. The recording and slides for the webinar...
