EmergencyEMERGENCY? Get 24/7 Help Now!

How to convert MySQL’s SHOW PROFILES into a real profile

 | February 20, 2012 |  Posted In: Insight for Developers, MySQL

SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. By that, I mean that it doesn’t show similar phases aggregated together, doesn’t sort them by worst-first, and doesn’t show the relative amount of time consumed. I’ll profile the “nicer_but_slower_film_list” included with the Sakila sample […]

Read More

Why don’t our new Nagios plugins use caching?

 | February 19, 2012 |  Posted In: Insight for DBAs, MySQL

In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don’t use caching. It’s worth answering in a post rather than a comment, because there is an important principle that needs to be understood to monitor servers correctly. But first, some history. When I […]

Read More

Announcing MySQL Monitoring Plugins from Percona

 | February 17, 2012 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Software

We’ve released a new set of monitoring plugins for MySQL servers and related software. With these plugins, you can set up world-class graphing and monitoring for your MySQL servers, using your own on-premises Cacti and Nagios software. The Cacti plugins are derived from an existing set of templates we’ve been using for several years, but […]

Read More

Optimize Your SQL With Percona’s Online Query Advisor!

 | February 15, 2012 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers can use lint-check tools to warn about bugs in their C?

Such a simple mistake, but it’s the kind of thing that James Bond movies are made of, isn’t it? […]

Read More

Announcing Percona Toolkit Release 2.0.3

 | February 6, 2012 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Software

We’ve released Percona Toolkit 2.0.3, with a couple of major improvements and many minor ones. You can download it, read the documentation, and get support for it. What’s new? You can read the changelog for the details, but here are the highlights: Brand new pt-diskstats, thanks to Brian Fraser. This tool is completely rewritten, and […]

Read More

Verifying backup integrity with CHECK TABLES

 | February 1, 2012 |  Posted In: Insight for DBAs, MySQL

An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent post on InnoDB’s handling of corrupted pages, because the best way to check for corruption is with CHECK TABLES, but if a page is corrupt, InnoDB will crash the server to prevent access to the […]

Read More

MySQL Configuration Wizard Updated

 | January 26, 2012 |  Posted In: Insight for DBAs, MySQL

We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don’t remember that announcement, here’s the short version: this is a tool to help you generate my.cnf files based on your server’s hardware and other characteristics. We’ve gotten really good feedback on this tool, including […]

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.