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...
by Arunjith Aravindan | Dec 12, 2022 | Insight for DBAs, MySQL, Percona Software
Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in a controlled manner that does not disrupt application users or cause application downtime. One of the tools in Percona Toolkit is...
by Mani Paluru | Dec 8, 2022 | Insight for DBAs, MySQL
In this blog, I’m going to discuss how to easily skip the replication errors in GTID (Global Transaction Identifier)-based replication. In the MySQL world, if replication is broken we all use the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; to skip the...
by Zsolt Parragi | Dec 8, 2022 | MySQL, Percona Software
Percona Server for MySQL 8.0.30-22 introduces a new authentication plugin, named authentication_fido. With this new plugin, it is possible to perform multi-factor authentication using hardware keys, or single-factor passwordless authentication with the same keys. This...
by Zsolt Parragi | Dec 6, 2022 | Insight for DBAs, MySQL, Percona Software
Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. All improvements are in technical preview. A description of the existing plugin features and...
![[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)
