Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
May 9, 2019
Improving OLAP Workload Performance for PostgreSQL with ClickHouse Database
Every database management system is not optimized for every workload. Database systems are designed for specific loads, and thereby give [...]
May 1, 2019
Benchmark ClickHouse Database and clickhousedb_fdw
In this research, I wanted to see what kind of performance improvements could be gained by using a ClickHouse data [...]
April 25, 2019
Creating Custom Sysbench Scripts
Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on [...]
March 20, 2019
MongoDB on ARM Processors
ARM processors have been around for a while. In mid-2015/2016 there were a couple of attempts by the community to [...]
March 6, 2019
Settling the Myth of Transparent HugePages for Databases
The concept of Linux HugePages has existed for quite a while: for more than 10 years, introduced to Debian in [...]
February 25, 2019
MySQL Challenge: 100k Connections
In this post, I want to explore a way to establish 100,000 connections to MySQL. Not just idle connections, but [...]
February 22, 2019
Measuring Percona Server for MySQL On-Disk Decryption Overhead
Percona Server for MySQL 8.0 comes with enterprise grade total data encryption features. However, there is always the question of [...]
February 21, 2019
MySQL 8 is not always faster than MySQL 5.7
MySQL 8.0.15 performs worse in sysbench oltp_read_write than MySQL 5.7.25 Initially I was testing group replication performance and was puzzled [...]
February 19, 2019
How Network Bandwidth Affects MySQL Performance
Network is a major part of a database infrastructure. However, often performance benchmarks are done on a local machine, where [...]
February 15, 2019
ClickHouse Performance Uint32 vs Uint64 vs Float32 vs Float64
While implementing ClickHouse for query executions statistics storage in Percona Monitoring and Management (PMM), we were faced with a question [...]
December 20, 2018
Benchmark PostgreSQL With Linux HugePages
Linux kernel provides a wide range of configuration options that can affect performance. It’s all about getting the right configuration [...]
December 20, 2018
Percona Database Performance Blog 2018 Year in Review: Top Blog Posts
Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. The closing of a year [...]
September 28, 2018
Scaling Percona Monitoring and Management (PMM)
Starting with PMM 1.13, PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU [...]
September 26, 2018
Scaling IO-Bound Workloads for MySQL in the Cloud – part 2
This post is a followup to my previous article