by Mauricio Cacho | Mar 6, 2023 | Insight for DBAs, MySQL
MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know what the right Redo Log size is? We will walk through how to figure that out in this blog. We already have a couple of posts related to this...
by Uday Varagani | Mar 3, 2023 | Insight for DBAs, MySQL, Percona Software
This post was originally published in October 2018 and was updated in March 2023. pt-query-digest is one of the most commonly used tools for query auditing in MySQL. By default, pt-query-digest reports the top ten queries consuming the most amount of time inside...
by Fernando Mattera | Mar 3, 2023 | Insight for DBAs, MySQL, Percona Software
Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, very frequently, answering questions that are not always easy to answer. A few days ago, a client asked us the following question:...
by Sergey Pronin | Mar 1, 2023 | Cloud, MySQL, Percona Software
Public cloud spending is slowing down. Quarter-over-quarter growth is no longer hitting 30% gains for AWS, Google, and Microsoft. This is businesses’ response to tough and uncertain macroeconomic conditions, where organizations scrutinize their public cloud...
by David Stokes | Mar 1, 2023 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 5.7 has had a good, long run, but the official End of Life is October of 2023. The Era of MySQL 5.x will be over, and only MySQL 8.0 will be officially supported. Yup, six months away. So if you are running MySQL, you need to consider upgrading to...
by Dmitry Lenev | Feb 20, 2023 | MySQL, Percona Software, Security
Introduction/TLDR: We are considering changing EXPLAIN in Percona Server for MySQL to require less privileges for providing execution plans for INSERT/UPDATE/DELETE statements (and possibly changing the behavior for EXPLAIN SELECT as well), to make it more convenient...
by Edwin Wang | Feb 16, 2023 | Database Trends, Insight for DBAs, MySQL
ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s Level 3 programming interview. I wondered, does that mean ChatGPT is ready to replace MySQL DBAs, too? No. Let me show you why. Recently, one of our clients...
by Vadim Tkachenko | Feb 15, 2023 | MySQL, Percona Software
Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL (Percona Server for MySQL: Automatic Cloud Deployment With Terraform) and Percona Monitoring and Management (Deploying Percona Monitoring and Management (PMM) With Terraform). Now we...
by Yves Trudeau | Feb 15, 2023 | Insight for DBAs, MySQL, Storage Engine
Bloom filters are an essential component of an LSM-based database engine like MyRocks. This post will illustrate through a simple example how bloom filters work in MyRocks. Why? With MyRocks/RocksDB, data is stored in a set of large SST files. When MyRocks needs to...
by Peter Sylvester | Feb 13, 2023 | Cloud, Insight for DBAs, MySQL
Recently, I was working with my colleagues Edwin Wang and Taras Onishchuk and found an interesting edge case involving a situation where a replica running Percona Server for MySQL 5.7, external to AWS Aurora instance version 2.10.2 (5.7-compatible), broke. I recreated...
by Lalit Choudhary | Feb 10, 2023 | Insight for DBAs, MySQL, Percona Software, Storage Engine
Percona XtraBackup is an open source hot backup utility for MySQL-based servers. To take consistent and hot backup, it uses various locking methods, especially for non-transactional storage engine tables. This blog post discusses the cause and possible solution for...
by Marcelo Altmann | Feb 10, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Amazon instance profiles are used to pass IAM roles to an EC2 instance. This IAM role can be queried using EC2 instance metadata to access an S3 bucket. Please check Amazon’s Official Documentation for more information. Today we are happy to announce that...
by David Stokes | Jan 26, 2023 | Insight for DBAs, MySQL
Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic. A bug appeared in MySQL’s recently released...
by Uday Rajarapu | Jan 25, 2023 | Insight for DBAs, MySQL
Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive...
by Mughees Ahmed | Jan 23, 2023 | Insight for DBAs, MySQL
A couple of days ago I was creating an index on the source and when I checked the replica side it was not replicated, so I just wanted to explain how the replication filter may increase the complexity of your DBA operations. Replication occurs by reading events from...
by Yunus Shaikh | Jan 23, 2023 | Insight for DBAs, MySQL, Percona Software
We had a couple of cases where clients reported that the MySQL error log was flooded with the below note: Shell 2023-01-18T13:07:56.946323Z 2 [Note] InnoDB: Stopping purge 2023-01-18T13:07:56.948621Z 2 [Note] InnoDB: Resuming purge 2023-01-18T13:08:27.229703Z 2 [Note]...
by Marco Tusa | Jan 20, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
How can we fix a nasty out-of-space issue leveraging the flexibility of Percona Operator for MySQL? When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate to data on disk. This is even more...
by David Stokes | Jan 19, 2023 | Insight for DBAs, MySQL
Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a major change but you do need to be aware of some changes just in case they have the potential to send you into the court of Murphy’s Law. So let’s look...
by Eduardo Krieg | Jan 19, 2023 | Insight for DBAs, MySQL, Percona Software
16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. While the technologies have evolved and matured enough, there are still some people thinking that MySQL is only for...
by Denis Subbota | Jan 9, 2023 | Benchmarks, Insight for DBAs, MySQL, Storage Engine
Looking at how people are using COUNT(*) and COUNT(col), it looks like most of them think they are synonyms and just use what they happen to like, while there is a substantial difference in performance and even query results. Also, we find a difference in execution on...
![[BUG] Stopping Purge/Resuming Purge in Error Logs After Upgrade to MySQL 5.7.40](https://www.percona.com/blog/wp-content/uploads/2023/01/Resuming-Purge-in-Error-Logs-After-Upgrade-to-MySQL-5.7.40.jpg)
