by Peter Zaitsev | Aug 14, 2019 | MySQL, Percona Software
While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important. In...
by Marco Tusa | Aug 13, 2019 | Insight for DBAs, MySQL
by Vinicius Grippa | Aug 1, 2019 | MySQL
In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, building the standby replica from scratch. The clone plugin permits cloning data locally or from a...
by marcos.albe | Jul 23, 2019 | MySQL
ERROR 1040…again A pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other...
by Alexey Stroganov | Jul 19, 2019 | MySQL
See part one of this series here. This post is part two of my series “Assessing MySQL Performance Amongst AWS Options”, taking a look at how current Amazon RDS services – Amazon Aurora and Amazon RDS for MySQL – compare with Percona Server with InnoDB and...
by Corrado Pandiani | Jul 17, 2019 | Insight for DBAs, MySQL
I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious issue because of the continuous outages of the service, as the customer had to constantly restart the server and wait for the next outage. What was...
by Carlos Tutte | Jul 5, 2019 | MySQL
During our work in support, we see this again and again: “I try to connect to MySQL and am getting a 1045 error”, and most times it comes accompanied with “…but I am sure my user and password are OK”. So we decided it was worth...
by Satya Bodapati | Jun 27, 2019 | MySQL
In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying “there is one disadvantage.” Beginning in MySQL 5.6, many DDLs including ALTER TABLE ADD INDEX became “ONLINE”. Meaning, when the...
by Borys Belinsky | Jun 26, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the...
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...
