Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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
September 20, 2018
Prometheus 2 Times Series Storage Performance Analyses
Prometheus 2 time series database (TSDB) is an amazing piece of engineering, offering a dramatic improvement compared to “v2” storage [...]
September 3, 2018
40 million tables in MySQL 8.0 with ZFS
In my previous blog post about millions of table in MySQL 8, I was able to create one million tables [...]
August 29, 2018
Scaling IO-Bound Workloads for MySQL in the Cloud
Is increasing GP2 volumes size or increasing IOPS for IO1 volumes a valid method for scaling IO-Bound workloads? In this [...]
August 7, 2018
Resource Usage Improvements in Percona Monitoring and Management 1.13
In Percona Monitoring and Management (PMM) 1.13 we have adopted Prometheus 2, and with this comes a dramatic improvement in [...]
August 1, 2018
Saving With MyRocks in The Cloud
The main focus of a previous blog post was the performance of MyRocks when using fast SSD devices. However, I [...]
July 18, 2018
Why Consumer SSD Reviews are Useless for Database Performance Use Case
If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases [...]