Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
August 6, 2020
How Can ScaleFlux Handle MySQL Workload?
Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I [...]
July 29, 2020
Checkpointing in MySQL and MariaDB
Continuing with the checkpointing topic I restarted a month ago with MongoDB and followed with PostgreSQL, I wanted to check [...]
July 28, 2020
Evaluating Checkpointing in PostgreSQL
Continuing with the checkpointing topic I started a month ago with my blog post MongoDB Checkpointing Woes, this time I [...]
July 27, 2020
The Transaction Behavior Impact of innodb_rollback_on_timeout in MySQL
I would say that innodb_rollback_on_timeout is a very important parameter. In this blog, I am going to explain “innodb_rollback_on_timeout” and [...]
July 27, 2020
ClickHouse and ColumnStore in the Star Schema Benchmark
There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform [...]
June 25, 2020
MongoDB Checkpointing Woes
In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for [...]
June 24, 2020
Evaluating MongoDB Under Python TPCC 1000W Workload
Following my blog post Evaluating the Python TPCC MongoDB Benchmark, I wanted to evaluate how MongoDB performs under workload with [...]
June 15, 2020
Evaluating the Python TPCC MongoDB Benchmark
I was looking for a tool that could evaluate MongoDB performance under a complex workload, besides simple key-value operations that [...]
April 14, 2020
Benchmarking: More Stable Results with CPU Affinity Setting
When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good [...]
April 13, 2020
Need to Connect to a Local MySQL Server? Use Unix Domain Socket!
When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local [...]
April 10, 2020
Evaluating Group Replication Scaling for I/O Bound Workloads
In this post, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes [...]
April 9, 2020
Evaluating Group Replication with Multiple Writers in MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities to handle several writers, that is, when the read-write [...]