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

Where is the MySQL 5.7 root password?

 | May 18, 2016 |  Posted In: MySQL

MySQL 5.7 root password

In this blog, we’ll discuss how to find the MySQL 5.7 root password. While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the installation itself can be considered secure. It’s a necessary change, […]

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

MySQL “Got an error reading communication packet” errors

 | May 16, 2016 |  Posted In: MySQL

Galera Error Failed to Report Last Committed

In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors, and how to address them. In Percona’s managed services, we often receive customer questions on communication failure errors – where customers are faced with intermittent “Got an error reading communication packets” messages. I thought this topic deserved […]

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

Quick start MySQL testing using Docker (on a Mac!)

 | May 11, 2016 |  Posted In: Docker, MySQL

docker-logo

In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment. Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. The Docker ecosystem seems to be moving quickly, however, and simple “getting started” or “how-to” type articles that are easy […]

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

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

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.