EmergencyEMERGENCY? Get 24/7 Help Now!

Fixing MySQL scalability problems with ProxySQL or thread pool

 | May 19, 2016 |  Posted In: MySQL

Fixing MySQL scalability problems

In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool. In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommendation to play black magic with innodb_thread_concurrency and innodb_spin_wait_delay doesn’t always help. We need a different solution to deal with this scaling problem. All […]

Read More

MySQL 5.7 read-write benchmarks

 | May 17, 2016 |  Posted In: MySQL

MySQL 5.7 read-write benchmarks

In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks. In my past blogs I’ve posted benchmarks on MySQL 5.5 / 5.6 / 5.7 in OLTP read-only workloads. For example: MySQL 5.7 sysbench OLTP read-only results: is MySQL 5.7 really faster? MySQL 5.7 primary key lookup results: is it really faster? ProxySQL […]

Read More

ProxySQL versus MaxScale for OLTP RO workloads

 | May 12, 2016 |  Posted In: MySQL

ProxySQL versus MaxScale for OLTP RO workloads

In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads. Continuing my series of READ-ONLY benchmarks (you can find the other posts here: https://www.percona.com/blog/2016/04/07/mysql-5-7-sysbench-oltp-read-results-really-faster/ and https://www.percona.com/blog/2016/03/28/mysql-5-7-primary-key-lookup-results-is-it-really-faster), in this post I want to see how much overhead a proxy adds. At this In my opinion, there are only two solid proxy software options for MySQL […]

Read More

Query Rewrite plugin can harm performance

 | May 10, 2016 |  Posted In: MySQL

Query Rewrite plugin can harm performance

In this blog post, we’ll discuss how the Query Rewrite plugin can harm performance. MySQL 5.7 comes with Query Rewrite plugin, which allows you to modify queries coming to the server. (You can view the details here: https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html.) It is based on the audit plugin API, and unfortunately it suffers from serious scalability issues (which seems […]

Read More

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

Evaluating Database Compression Methods: Update

and  | April 13, 2016 |  Posted In: Benchmarks, MySQL

Database Compression Methods

This blog post is an update to our last post discussing database compression methods, and how they stack up against each other.  When Vadim and I wrote about Evaluating Database Compression Methods last month, we claimed that evaluating database compression algorithms was easy these days because there are ready-to-use benchmark suites such as lzbench. As […]

Read More

Downloading MariaDB MaxScale binaries

 | April 11, 2016 |  Posted In: MySQL

Downloading MariaDB MaxScale binaries

In this blog post we’ll discuss a caveat when downloading MariaDB MaxScale binaries. Following the previous performance results in my last two posts on sysbench and primary keys (https://www.percona.com/blog/2016/04/07/mysql-5-7-sysbench-oltp-read-results-really-faster/ and https://www.percona.com/blog/2016/03/28/mysql-5-7-primary-key-lookup-results-is-it-really-faster/), I wanted to measure overhead from proxies servers like ProxySQL and MaxScale. Unfortunately, I found that MaxScale binaries are not available without registering on the […]

Read More

MySQL 5.7 sysbench OLTP read-only results: is MySQL 5.7 really faster?

 | April 7, 2016 |  Posted In: MySQL

MySQL Document Store

This blog will look at MySQL 5.7 sysbench OLTP read-only results to determine if they are faster than previous versions. As promised in my previous post, I have checked MySQL 5.7 performance against previous versions in a different workload. This time, I will use sysbench OLTP read-only transactions (read-write transactions are part of future research, […]

Read More

MySQL 5.7 primary key lookup results: is it really faster?

 | March 28, 2016 |  Posted In: MySQL

MySQL 5.7 primary key lookup results

This blog examines MySQL 5.7’s primary key lookup results, and determines if MySQL 5.7 is really faster than its early versions. MySQL 5.7 was released some time ago, and now that the dust has settled it’s a good time to review its performance improvements. I’m not doing this just to satisfy my own curiosity! Many […]

Read More

Percona Server 5.7 performance improvements

, and  | March 17, 2016 |  Posted In: Benchmarks, MySQL, MySQL 5.7, 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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.