by Tibor Korocz | Jun 26, 2019 | Insight for Developers, MySQL
In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we aren’t cautious. For this example, I am only going to use the SLEEP function to...
by Tibor Korocz | Jun 25, 2019 | Cloud, MySQL
Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why. I am not going to go into the details of how Aurora works, as there are other blog posts discussing that. Here I am...
by Carlos Salguero | Jun 24, 2019 | MySQL
I receive many questions about errors being reported about pt-kill… and often those errors are not real. The main problem I have found is that pt-kill is hard to understand and the documentation doesn’t have many examples (I’ll add them), so, I...
by Borys Belinsky | Jun 19, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.44-28.34 is now the current release, based on the...
by Mike Benshoof | Jun 5, 2019 | Database Trends, MySQL
It used to be easy: a company developed a new application, chose a database solution, launched the new application and then tuned the chosen database solution. A team of DBAs looked at the infrastructure as well as the workload and made changes (or suggestions) as...
by Uday Varagani | Jun 4, 2019 | MySQL, Percona Software
Recently, I received a support request where the customer wanted to convert an INTEGER column to BIGINT on two tables. These tables are related by a foreign key, and it is a 3 node PXC cluster. These tables are 20GB and 82 GB in size and DDL’s on such tables in...
by Corrado Pandiani | May 13, 2019 | MySQL, Open Source, Percona Software
“Hey, what’s going on with my applications? I installed a newer version of MySQL. I have queries that perfectly run with the older version and now I have a lot of errors.” This is a question some customers have asked me after upgrading MySQL. In this...
by Sveta Smirnova | May 7, 2019 | MariaDB, MySQL, Percona Events, Percona Live
Less than one month left until Percona Live. This time the Committee work was a bit unusual. Instead of having one big committee for the whole conference we had a few mini-committees, each responsible for a track. Each independent mini-committee, in turn, had a leader...
by Sveta Smirnova | May 2, 2019 | MySQL, Percona Services, Percona Software
When users experience memory usage issues with any software, including MySQL®, their first response is to think that it’s a symptom of a memory leak. As this story will show, this is not always the case. This story is about a bug. All Percona Support customers...
by Matthew Boehm | Apr 25, 2019 | Benchmarks, Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Services
Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on it daily, and even Oracle uses it when blogging about new features in MySQL 8. Sysbench comes with several pre-defined benchmarking tests....
by Borys Belinsky | Feb 28, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.43-28.32 on February 28, 2019. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10...
by Borys Belinsky | Feb 28, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.25-31.35 on February 28, 2018. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10...
by Dmitriy Kostiuk | Jan 4, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.42-28.30 (PXC) on January 4, 2019. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.42-28.30 is now the current release, based on the following:...
by Dmitriy Kostiuk | Jan 4, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.24-31.33 is now the current release, based on the...
by Tibor Korocz | Jan 2, 2019 | MySQL, Percona Software
Recently, I encountered a situation where MySQL gave error messages that I had never seen before: MySQL 2018-12-12T14:36:45.571440Z 0 [ERROR] Error log throttle: 150 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:36:45.571456Z 0...
by Marco Tusa | Nov 15, 2018 | Insight for DBAs, MySQL, PostgreSQL
In this series of blog posts, I’m going to look at some high availability reference architecture solutions over geographically distributed areas. The Problem Nowadays, when businesses plan a new service or application, it is very common for them to worry about...
by Tibor Korocz | Nov 2, 2018 | Cloud
Recently, I’ve been working with a customer to evaluate the different cloud solutions for MySQL. In this post I am going to focus on maintenance windows and requirements, and what the different cloud platforms offer. Why is this important at all? Maintenance...
by Tibor Korocz | Oct 17, 2018 | Insight for DBAs, MySQL
Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it...
by Borys Belinsky | Oct 2, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are available from the downloads section or from our software repositories. This release resolves a critical regression in...
by Borys Belinsky | Sep 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
This release has been superseded by 5.7.23-31.31.2 after a critical regression was found. Please update to the latest release. Percona is glad to announce the release of Percona XtraDB Cluster 5.7.23-31.31 on September 26, 2018. Binaries are available from...
