Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 16, 2023
Streamline the SQL Code: Guide to pgFormatter
In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free [...]
August 3, 2023
The Invisibilities in MySQL 8.0
In this article, I want to discuss a couple of pretty new features in MySQL 8.0 — and an older [...]
August 1, 2023
Migrating From On-Prem to RDS MySQL/Aurora? DEFINERS Is the Answer
Hello friends! If you plan to migrate your database from on-prem servers to RDS (either Aurora or MySQL RDS), you [...]
July 31, 2023
Dynamic SQL Workaround in MySQL: Prepared Statements
Dynamic SQL is a desirable feature that allows developers to construct and execute SQL statements dynamically at runtime. While MySQL [...]
July 26, 2023
Ten Recommendations for Running Your MongoDB Environment
MongoDB is a non-relational document database that provides support for JSON-like storage. It provides a flexible data model allowing you [...]
July 25, 2023
20X Faster Backup Preparation With Percona XtraBackup 8.0.33-28!
In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 (PXB), which significantly reduces the time to [...]
July 20, 2023
How To Measure the Network Impact on PostgreSQL Performance
It is very common to see many infrastructure layers standing between a PostgreSQL database and the Application server. The most [...]
July 19, 2023
Extensibility in MySQL Is Easy
Well, “easy” if you know just a tiny bit of C++. MySQL is well known for its ease of use, [...]
July 15, 2023
An Overview of Indexes in MySQL 8.0: MySQL CREATE INDEX, Functional Indexes, and More
This blog was originally published in January 2022 and was updated in July 2023. Working with hundreds of different customers, [...]
July 7, 2023
Online Data Type Change in PostgreSQL
Changing the data type on a column in a big table is almost always a pain. It can lock out [...]
July 5, 2023
The Impacts of Fragmentation in MySQL
Fragmentation is a common concern in some database systems. Highly fragmented tables can affect performance and resource allocation. But reducing [...]
June 20, 2023
Deploy Django on Kubernetes With Percona Operator for PostgreSQL
Developers need an efficient, reliable way to run their Django applications with a robust PostgreSQL. Percona Operator for PostgreSQL offers [...]
June 15, 2023
Using PostGIS To Enable Better Performance in PostgreSQL
This post was originally published in 2020 and has been updated in 2023. Mastering Geographical Information Systems, better known simply [...]
June 1, 2023
Process MySQL LIMIT & ORDER BY for Performance Optimization
Updated June 1, 2023. Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL [...]
April 26, 2023
Open Source Software Security: Is Open Source Software Safe?
Even though open source software is firmly in the mainstream, used widely by businesses, governments, and everyone who owns a [...]
April 17, 2023
Percona Monitoring and Management and Datadog Integration
So your company is using Datadog on the global level. Still, as DBA, you want to use Percona Monitoring and [...]
April 4, 2023
MySQL 5.7 Upgrade Issue: Reserved Words
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting [...]
March 24, 2023
A Workaround for The “RELOAD/FLUSH_TABLES privilege required” Problem When Using Oracle mysqldump 8.0.32
In MySQL Server 8.0.32, Oracle fixed Bug #105761: “mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit) which caused [...]
March 24, 2023
Replication Issues and Binlog Compressor
You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article [...]
March 8, 2023
Dealing With “Too Many Connections” Error in MySQL 8
Over the years of being a DBA, I had to deal with all kinds of problems in the database. One [...]