EmergencyEMERGENCY? Get 24/7 Help Now!

Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A

 | May 20, 2016 |  Posted In: EXPLAIN, MySQL, MySQL Webinars

Troubleshooting Slow Queries

In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar. First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with […]

Read More

Percona XtraDB Cluster 5.6.29-25.15 is now available

 | May 20, 2016 |  Posted In: MySQL

Percona XtraDB Cluster 5.6

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on May 20, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.29-25.15 is now the current release, based on the following: Percona Server 5.6.29-76.2 Galera Replicator 3.15 Codership wsrep API 25.15 All of Percona software is open-source […]

Read More

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

Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help

 | May 19, 2016 |  Posted In: MongoDB, Performance Schema

mongodb-support-leaf

Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.” David will discuss the pros and cons of a few MongoDB schema design patterns on a stand-alone machine, and then will look at how sharding […]

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

MySQL Got an error reading communication packet errors

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

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.