Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
May 24, 2022
A Quick Peek at the PostgreSQL 15 Beta 1
PostgreSQL 15 Beta 1 was announced on May 15th and to keep with the spirit of past peeks at MySQL [...]
May 9, 2022
MyDumper 0.12.3-1 is Now Available
The new MyDumper 0.12.3-1 version, which includes many new features and bug fixes, is now available. You can download the [...]
April 27, 2022
A Quick Peek At MySQL 8.0.29
Oracle released MySQL Server 8.0.29 on April 26th and this is a quick review of the release notes. I have [...]
April 27, 2022
Working With Large PostgreSQL Databases
It’s a funny thing when the topic of database sizes comes up. Calling one small, medium, large, or even huge [...]
April 22, 2022
Zero Impact on Index Creation with Amazon Aurora 3
In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL [...]
April 20, 2022
Finding Differences Between MySQL Servers
When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through [...]
April 19, 2022
PostgreSQL 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion
Concurrent access to data within PostgreSQL is managed with the Multiversion Concurrency Control (MVCC) model. Data snapshots are maintained for [...]
April 15, 2022
Correcting MySQL Inaccurate Table Statistics for Better Execution Plan
Abstract: By diving into the details of our case study, we will explain how incorrect table statistics may lead the [...]
April 13, 2022
Overcoming VACUUM WRAPAROUND
Transaction ID Wraparound occurs when the VACUUM process cannot keep up with database activity and the PostgreSQL service is forced [...]
April 6, 2022
Upgrade your Libraries: Authentication Plugin ‘caching_sha2_password’ Cannot be Loaded
For my previous blog post on the topic, I received plenty of questions about why I did not cover the [...]
April 5, 2022
Hidden Cost of Foreign Key Constraints in MySQL
Do you wonder if MySQL tells you the truth about writes to tables that have foreign key constraints? The situation [...]
March 30, 2022
MySQL Shell For VS Code – Your New GUI?
MySQL Shell For VS Code integrates the MySQL Shell directly into VS Code development workflows and was released last week. [...]
March 29, 2022
Migrating to utf8mb4: Things to Consider
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor [...]
March 28, 2022
MariaDB 10.9 Quick Peek
MariaDB 10.9 is a preview release of the popular open source database server and is considered alpha level code (pronounced: [...]
March 25, 2022
Percona Monitoring and Management Security Threat Tool
Percona Monitoring and Management (PMM) is a multi-faceted tool that includes the Security Threat Tool which provides the ability to [...]
March 24, 2022
PostgreSQL From the Perspective of a MySQL DBA
DBAs can be set in their ways. Oftentimes, we start with a particular flavor and from that moment until the [...]
March 24, 2022
A Dive Into MySQL Multi-Threaded Replication
For a very long part of its history, MySQL replication has been limited in terms of performance. Because there was [...]
March 23, 2022
MySQL 8: Multi-Factor Authentication Overview
As part of my ongoing series around MySQL 8 user administration, I’d like to cover one of the new features [...]
March 22, 2022
MySQL 8: Password Verification Policy
In keeping with my MySQL 8 user administration and security theme, I’d like to discuss the password verification-required policy introduced [...]
March 22, 2022
Authentication Plugin ‘***’ Cannot Be Loaded: How MySQL Searches Client-Side Plugins
When MySQL client connects to the server it uses one of the authentication plugins. On the server-side, plugins are located [...]