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...
by Smit Arora | Jan 5, 2023 | Insight for DBAs, MySQL
Space constraint has been an endless and painstaking process for many of us, especially in systems that have a high number of transactions and data growth exceeding hundreds of GBs in a matter of days. In this blog, I will share a solution to remove this space and...
by Brijesh Chauhan | Jan 5, 2023 | Insight for DBAs, MySQL, Percona Software
Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 to 8.0.27. After this version upgrade, we experienced issues with backups and replication for one of the nodes. In this article, I will explain these...
by Bhuvanes Waran | Jan 3, 2023 | Insight for DBAs, MySQL
In Managed Services, we have many customers, and as each has a different kind of config and environment, working on their environment is always fun and interesting. In this blog post, I will showcase an issue we faced when dropping a table and how it was resolved....
by Gaurav Pareek | Dec 28, 2022 | Insight for DBAs, MySQL
In managed services, we get requests to migrate from traditional to GTID-based replication. However, the customer does not want to first enable the GTID on the source node (production). Before MySQL 8.0.23, replication from the disabled GTID source to an enabled GTID...
by Brijesh Chauhan | Dec 28, 2022 | Cloud, Insight for DBAs, MySQL
Recently I came across an interesting investigation about long-running transactions getting killed on an Aurora Reader instance. In this article, I will explain why it is advisable to avoid long-running transactions on Aurora readers when executing frequent DDL...
by Edwin Wang | Dec 27, 2022 | Insight for DBAs, MySQL
There are eight configuration options related to the character_set in MySQL, as shown below. Without reading the MySQL Character Set documentation carefully, it could be hard to know what these configuration options are used for. In addition, for some of the options,...
by Yves Trudeau | Dec 23, 2022 | Cloud, Insight for DBAs, MySQL, Storage Engine
I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. Although MyRocks is very efficient for writes, I chose a more generic workload that will provide a different MyRocks use case....
by Sergey Pronin | Dec 15, 2022 | Cloud, MySQL, Percona Software, Security
Operators hide the complexity of the application and Kubernetes. Instead of dealing with Pods, StatefulSets, tons of YAML manifests, and various configuration files, the user talks to Kubernetes API to provision a ready-to-use application. An Operator automatically...
![[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)
