Monthly Archives - May 2016

CPU governor performance

CPU governor performance

In this blog, we’ll examine how CPU governor performance affects MySQL.
It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance.
Before jumping to results, let’s review what drivers manage CPU frequency. Traditionally, the default driver was […]

Read more

Percona Server 5.7: multi-threaded LRU flushing

In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL.
In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based on our 5.6 experience we have decided to attack the single-page […]

Read more

MySQL High Availability: The Road Ahead for Percona and XtraDB Cluster

High Availability

This blog post discusses what is going on in the MySQL high availability market, and what Percona’s plans are for helping customers with high availability solutions.
One thing I like to tell people is that you shouldn’t view Percona as a “software” company, but as a “solution” company. Our goal has always been to provide the […]

Read more

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

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

Best Practices for Configuring Optimal MySQL Memory Usage

Optimal MySQL Memory Usage

In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage.
Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal performance and stability. As of MySQL 5.7, the default configuration uses a very limited amount of […]

Read more