EmergencyEMERGENCY? Get 24/7 Help Now!

pt-online-schema-change (if misused) can’t save the day

 | May 24, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit, Replication

pt-online-schema-change

In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production […]

Read More

Better high availability: MySQL and Percona XtraDB Cluster with good application design

 | December 21, 2015 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster, Replication, XtraDB Cluster

High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of many reads, with usually few writes. There are exceptions of course – MMO games […]

Read More

Using dbsake to recover table structure from .frm files and process mysqldump output

 | December 16, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL

We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel Nieto about how we can recover structures from .frm files using MySQL utilities. This works pretty well and we prefer […]

Read More

Slow query graphs using Performance Schema and Graphite

 | October 20, 2015 |  Posted In: Graphite, Insight for DBAs, MySQL, Performance Schema, Query Analytics

Grpahite Slow log compiled

I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having visibility of the slow queries execution time on a graph? Let’s do it. We’ve already described how to get query […]

Read More

MySQL query digest with Performance Schema

 | October 13, 2015 |  Posted In: Insight for DBAs, Performance Schema, Query Analytics

Data Analysis

Query analysis is a fantastic path in the pursuit to achieve high performance. It’s also probably the most repeated part of a DBA’s daily adventure. For most of us, the weapon of choice is definitely pt-query-digest, which is one of the best tools for slow query analysis out there. Why not use pt-query-digest? Well, sometimes […]

Read More

When mysqld kills mysqld

 | October 9, 2015 |  Posted In: Insight for DBAs, MySQL

Server Shutdown

The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion we had about that internally. Our client wanted Peter to identify the culprit behind periodic shutdowns. This proved to be […]

Read More

Webinar: Introduction to MySQL SYS Schema follow up questions

 | September 16, 2015 |  Posted In: Insight for DBAs, MySQL, MySQL 5.7, MySQL Webinars, Performance Schema

Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream. Can i have the performance_schema enabled in 5.6 and then install the sys schema? Or they are one and the same? You need to […]

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.