EmergencyEMERGENCY? Get 24/7 Help Now!

Correct Index Choices for Equality + LIKE Query Optimization

 | April 11, 2017 |  Posted In: Insight for DBAs, MySQL

Query Optimization

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:

And a query that looked like this:

The table had an index t_msg that wasn’t […]

Read More

ProxySQL Rules: Do I Have Too Many?

 | April 10, 2017 |  Posted In: 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 is heavily based […]

Read More

Non-Deterministic Order for SELECT with LIMIT

 | April 7, 2017 |  Posted In: Insight for DBAs, MySQL

Non-Deterministic Order

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 the same values can be sorted differently. To fix this […]

Read More

Dealing with MySQL Error Code 1215: “Cannot add foreign key constraint”

 | April 6, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

MySQL error code 1215

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 trying to create a foreign key and can’t get it working” or “Why am I unable to create a […]

Read More

Evaluation of PMP Profiling Tools

 | April 5, 2017 |  Posted In: Benchmarks, MySQL, Percona Toolkit

PMP Profiling Tools

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 tool from Percona Toolkit (inspired by http://poormansprofiler.org). The pt-pmp tool collects application stack traces GDB and then […]

Read More

Percona Server for MySQL 5.7.17-13 is Now Available

 | April 5, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software

Percona Server for MySQL 5.7.18-15

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 on MySQL 5.7.17, including all the bug fixes in it, Percona Server for MySQL […]

Read More

Percona Live Webinar Thursday, April 6, 2017: Best Practices Migrating to Open Source Databases

 | April 4, 2017 |  Posted In: MariaDB, MongoDB, MySQL, open source databases, Percona Live, Technical 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 database use. It addresses both the advantages companies see […]

Read More

Percona Live Featured Session: Using SelectStar to Monitor and Tune Your Databases

 | April 4, 2017 |  Posted In: 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 environment. Make sure to read to the end to get a special Percona Live […]

Read More

New MariaDB Dashboard in Percona Monitoring and Management Metrics Monitor

 | April 3, 2017 |  Posted In: Events and Announcements, InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Monitoring and Management, Percona Server, Percona Software, PMM

MariaDB

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 builds on the efforts of the MariaDB development team to instrument the Aria Storage Engine Status Variables related […]

Read More