EmergencyEMERGENCY? Get 24/7 Help Now!

Performance improvements in Percona XtraDB Cluster 5.7.17-29.20

and  | April 19, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster

In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like. For the test, we used the sysbench OLTP_RW, UPDATE_KEY and UPDATE_NOKEY workloads with 100 tables, 4mln rows each, which gives about 100GB of datasize. In all […]

Read More

Evaluation of PMP Profiling Tools

 | April 5, 2017 |  Posted In: Benchmarks, MySQL, Percona Toolkit

PMP Profiling Tools

In this blog post, we’ll look at some of the available PMP profiling tools. While debugging or analyzing issues with Percona Server for MySQL, we often need a quick understanding of what’s happening on the server. Percona experts frequently use the pt-pmp tool from Percona Toolkit (inspired by http://poormansprofiler.org). The pt-pmp tool collects application stack traces GDB and then […]

Read More

Performance Evaluation of SST Data Transfer: With Encryption (Part 2)

 | March 30, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

SST Data Transfer

In this blog post, we’ll look at the performance of SST data transfer using encryption. In my previous post, we reviewed SST data transfer in an unsecured environment. Now let’s take a closer look at a setup with encrypted network connections between the donor and joiner nodes. The base setup is the same as the previous […]

Read More

Performance Evaluation of SST Data Transfer: Without Encryption (Part 1)

 | March 29, 2017 |  Posted In: Insight for DBAs, MySQL

SST Data Transfer

In this blog, we’ll look at evaluating the performance of an SST data transfer without encryption. A State Snapshot Transfer (SST) operation is an important part of Percona XtraDB Cluster. It’s used to provision the joining node with all the necessary data. There are three methods of SST operation available: mysqldump, rsync, xtrabackup. The most […]

Read More

Query rewrite plugin: scalability fix in MySQL 5.7.14

 | August 22, 2016 |  Posted In: Benchmarks, MySQL

query rewrite plugin

In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance. Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which includes fixes for this issue. I reran tests for MySQL 5.7.13 and 5.7.14 using the […]

Read More

Percona Server 5.7 parallel doublewrite

and  | May 9, 2016 |  Posted In: MySQL

Percona Server 5.7 parallel doublewrite

In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite. After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned off. We wanted to isolate the effect of the parallel LRU flusher, and the results validated […]

Read More

MySQL 5.7: initial flushing analysis and why Performance Schema data is incomplete

and  | May 3, 2016 |  Posted In: MySQL

Performance Schema data is incomplete

In this post, we’ll examine why in an initial flushing analysis we find that Performance Schema data is incomplete. Having shown the performance impact of Percona Server 5.7 patches, we can now discuss their technical reasoning and details. Let’s revisit the MySQL 5.7.11 performance schema synch wait graph from the previous post, for the case of […]

Read More

Percona Server 5.7 performance improvements

, and  | March 17, 2016 |  Posted In: Benchmarks, MySQL, Percona Server

Percona Server 5.7 performance improvements

In this blog post, we’ll be discussing Percona Server 5.7 performance improvements. Starting from the Percona Server 5.6 release, we’ve introduced several significant changes that help address performance problems for highly-concurrent I/O-bound workloads. Some of our research and improvements were re-implemented for MySQL 5.7 – one of the best MySQL releases. But even though MySQL 5.7 […]

Read More