EmergencyEMERGENCY? Get 24/7 Help Now!

CPU governor performance

 | May 6, 2016 |  Posted In: MySQL

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 […]

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

Best Practices for Configuring Optimal MySQL Memory Usage

 | May 3, 2016 |  Posted In: MySQL

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