Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 14, 2022
Parallel Commits for Transactions Using postgres_fdw on PostgreSQL 15
Consuming data from a remote foreign database into our local database just like another local table is a great feature [...]
January 17, 2022
Comparing Graviton (ARM) Performance to Intel and AMD for MySQL (Part 3)
Recently we published the first part (m5, m5a, m6g) and the second part (C5, C5a, C6g) of research regarding comparing [...]
January 4, 2022
Taking a Look at BTRFS for MySQL
Following my post MySQL/ZFS Performance Update, a few people have suggested I should take a look at BTRFS (“butter-FS”, “b-tree [...]
October 25, 2021
Comparing Graviton (ARM) Performance to Intel and AMD for MySQL (Part 2)
Recently we published the first part of research comparing Graviton (ARM) with AMD and Intel CPU on AWS. In the [...]
October 15, 2021
Comparing Graviton (ARM) Performance to Intel and AMD for MySQL
Recently, AWS presented its own CPU on ARM architecture for server solutions. It was Graviton. As a result, they update [...]
September 21, 2021
Making Aurora Write Latency 15x Higher (or More!) by Choosing a Bad Primary Key
Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact [...]
July 19, 2021
Performing ETL Using Inheritance in PostgreSQL
Good database maintenance includes not only performing the standard adding, updating, and deleting records, etc., but periodic edits to the [...]
July 9, 2021
MySQL/ZFS Performance Update
As some of you likely know, I have a favorable view of ZFS and especially of MySQL on ZFS. As [...]
March 8, 2021
Testing the Value of ScaleFlux Computational Storage Drive (CSD) for PostgreSQL
Some time ago we at Percona were approached by ScaleFlux Inc to benchmark their latest hardware appliance, the CSD 2000 [...]
February 26, 2021
Connection Queuing in pgBouncer: Is it a Magical Remedy?
Yes, this post is about connection queueing, not just pooling. Because “connection pooling” – pre-created connections as a pool – [...]
January 27, 2021
Deploying Any Version of Leading Open Source Databases for Tests and Experiments
I want to present a tool for running a specific version of open source databases in a single instance, replication [...]
January 22, 2021
PostgreSQL on ARM-based AWS EC2 Instances: Is It Any Good?
The expected growth of ARM processors in data centers has been a hot topic for discussion for quite some time, [...]
January 19, 2021
The MySQL Clone Wars: Plugin vs. Percona XtraBackup
Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a [...]
October 9, 2020
Amazon Aurora Multi-Primary First Impression
For what reason should I use a real multi-primary setup? To be clear, not a multi-writer solution where any node [...]
September 16, 2020
MongoDB 4.4 Performance Regression: Overwhelmed by Memory
There is a special collection of database bugs when the system starts to perform worse when given more resources. Examples [...]
September 15, 2020
Percona Server for MongoDB 4.2 vs 4.4 in Python TPCC Benchmark
Following my previous blogs on py-tpcc benchmark for MongoDB, Evaluating the Python TPCC MongoDB Benchmark and Evaluating MongoDB Under Python TPCC 1000W [...]
August 27, 2020
More on Checkpoints in InnoDB MySQL 8
Recently I posted about checkpointing in MySQL, where MySQL showed interesting “wave” behavior. Soon after Dimitri posted a solution with [...]
August 14, 2020
Part Two: How Many innodb_buffer_pool_instances Do You Need in MySQL 8 With a CPU-Bound Workload?
Part one of this series can be found here: How Many innodb_buffer_pool_instances Do You Need in MySQL 8? Following up [...]
August 13, 2020
How Many innodb_buffer_pool_instances Do You Need in MySQL 8?
Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How [...]