EmergencyEMERGENCY? Get 24/7 Help Now!

How X Plugin Works Under the Hood

 | September 16, 2016 |  Posted In: Insight for DBAs, MySQL

X Plugin

In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still […]

Read More

MHA Quick Start Guide

 | September 2, 2016 |  Posted In: High-availability, MySQL


MHA (Master High Availability Manager and tools for MySQL) is one of the most important pieces of our managed services. When properly set up, it can check replication health, move writer and reader virtual IPs, perform failovers, and have its output constantly monitored by Nagios. Is it easy to deploy and follows the KISS (Keep It […]

Read More

Amazon RDS and pt-online-schema-change

 | July 1, 2016 |  Posted In: MySQL

Amazon RDS and pt-online-schema-change

In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read More

Where is the MySQL 5.7 root password?

 | May 18, 2016 |  Posted In: MySQL

database security downtime poll.

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

Dealing with Jumbo Chunks in MongoDB

 | April 11, 2016 |  Posted In: MongoDB

Jumbo Chunks in MongoDB

In this blog post, we will discuss how to deal with jumbo chunks in MongoDB. You are a MongoDB DBA, and your first task of the day is to remove a shard from your cluster. It sounds scary at first, but you know it is pretty easy. You can do it with a simple command: […]

Read More

Setup a MongoDB replica/sharding set in seconds

 | January 28, 2016 |  Posted In: MongoDB, MySQL

MongoDB sharding

In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support. In this post I am going to walk through the different ways we […]

Read More

Dealing with corrupted InnoDB data

 | January 19, 2016 |  Posted In: MySQL


Data corruption! It can happen. Maybe because of a bug or storage problem that you didn’t expect, or MySQL crashes when a page checksum’s result is different from what it expected. Either way, corrupted data can and does occur. What do you do then? Let’s look at the following example and see what can be […]

Read More

pt-online-schema-change and innodb_stats_persistent on MySQL 5.6

 | November 13, 2015 |  Posted In: MySQL

Percona Toolkit

Recently we released an updated version of our Percona Toolkit with an important update for pt-online-schema-change if you use MySQL 5.6. A new parameter has been added, analyze-before-swap. What does it do? Let me explain it in more detail. A bug not a bug A customer contacted us because pt-online-schema-change caused hundred of queries to […]

Read More

Find unused indexes on MongoDB and TokuMX

 | August 21, 2015 |  Posted In: MongoDB

Finding and removing unused indexes is a pretty common technique to improve overall performance of relational databases. Less indexes means faster insert and updates but also less disk space used. The usual way to do it is to log all queries’ execution plans and then get a list of those indexes that are not used. […]

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.