MySQL Performance Blog - RSS Feed

Percona's MySQL & InnoDB performance and scalability blog

Latest articles

Why You Need To Keep Track of Bugs

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 8.0.32 that really caught my attention. This is a prime example of how a minor bug...

Identify Active Databases and Users in 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 databases and users. This task is part of regular maintenance and helps to manage disk space...

WAL Compression in PostgreSQL and Recent Improvements in Version 15

Attempts to compress PostgreSQL WAL at different levels have always been around since the beginning. Some of the built-in features (wal_compression) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. But it is time to take another look at the built-in wal_compression because PostgreSQL...

Backup Databases on Kubernetes With VolumeSnapshots

Databases on Kubernetes continue their rising trend. We see the growing adoption of our Percona Kubernetes Operators and the demand to migrate workloads to the cloud-native platform. Our Operators provide built-in backup and restore capabilities, but some users are still looking for old-fashioned ways, like storage-level snapshots (i.e., AWS EBS Snapshots)....

Working of MySQL Replication Filters When Using Statement-based and Row-based Replication

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 the binary log of the source and then executing them on the replica. The events in...

[BUG] Stopping Purge/Resuming Purge in Error Logs After Upgrade to MySQL 5.7.40

We had a couple of cases where clients reported that the MySQL error log was flooded with the below note: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] InnoDB: Stopping purge 2023-01-18T13:08:27.231552Z 2 [Note] InnoDB: Resuming purge ...

Help! I Am Out of Disk Space!

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 cumbersome when working on bare metal, as it is more difficult to add space when using...

A Quick Peek at MySQL 8.0.32

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 through the release notes to see what is new, changed, and deprecated. My own comments...

Why MySQL Could Be Slow With Large Tables

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 small projects or that it can’t perform well with large tables. Some startups adopted...

Keep Your Database Secure With Percona Advisors

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. It is partially true. The reason why we have Percona Advisors is to encode years of our database expertise and share it with the community, to automatically identify...

Discover, share and read the best on the web

Follow RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters! Get unfiltered news feeds or filter them to your liking.

Get Inoreader
Inoreader - Follow RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters!