Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
April 8, 2020
Evaluating Group Replication Scaling Capabilities in MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes [...]
March 30, 2020
Which Cloud Provider Performs Better for My Mysql Workload?
More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my [...]
March 26, 2020
Sysbench and the Random Distribution Effect
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool [...]
November 26, 2019
Comparing S3 Streaming Tools with Percona XtraBackup
Making backups over the network can be done in two ways: either save on disk and transfer or just transfer [...]
November 12, 2019
Watch Out for Disk I/O Performance Issues when Running EXT4
Recently, at Percona Live Europe 2019, Dimitri Kravchuk from Oracle mentioned that he observed some unclear drop in performance for [...]
August 15, 2019
A Faster, Lightweight Trigger Function in C for PostgreSQL
We have been writing blog posts about how to write simple extensions in C language and a little more complex [...]