by Nilnandan Joshi | Feb 26, 2014 | MySQL, Percona Services, Percona Software
While working on a recent support issue as a Percona Support Engineer, I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the table in a running production...
by Jericho Rivera | Feb 3, 2014 | Insight for DBAs, MySQL, Percona Software
This is the first in a series of posts highlighting a few of the seldom-used but still handy Percona Toolkit tools. Have you ever had a problem understanding the EXPLAIN statement output? And are you the type of person who would rather use the command line than a GUI...
by Hrvoje Matijakovic | Dec 20, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.6 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. This release has...
by Mike Benshoof | Nov 21, 2013 | Insight for DBAs, MySQL, Percona Software
Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high level, the two key components used in the environment were: Capistrano (scripted deployments) [website] Liquibase (database version control)...
by Daniel Nichter | Nov 1, 2013 | MySQL, Percona Software
In this post I wanted to highlight percona.com/bugs/<tool> , for example: percona.com/bugs/pt-stalk. This only works for Percona Toolkit. We often advise people to check a tool’s current bugs, but we don’t always say how. The official link for...
by Ryan Lowe | Sep 10, 2013 | Insight for DBAs, Insight for Developers, MySQL
The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE...
by Nilnandan Joshi | Aug 12, 2013 | MySQL, Percona Software
Percona Toolkit’s pt-archiver is one of the best utilities to archive the records from large tables to another tables or files. One interesting thing is that pt-archiver is a read-write tool. It deletes data from the source by default, so after archiving you...
by Hrvoje Matijakovic | Jul 18, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.1.10 on July 18th, 2013 (Downloads are available here). Bugs Fixed: Unfortunately, the relatively new –utc option for pt-heart was still broken because “MySQL interprets date as a value in the...
by Jaime Crespo | May 31, 2013 | Insight for DBAs, MySQL, Percona Software
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer...
by Daniel Nichter | May 6, 2013 | Percona Software
During the Percona Live MySQL Conference & Expo 2013 the week before last, we quietly released Percona Toolkit 2.2.2 with a few bug fixes: pt-archiver –bulk-insert may corrupt data pt-heartbeat –utc –check always returns 0 pt-query-digest 2.2...
by Fernando Ipar | Apr 23, 2013 | MySQL
I had the chance to work on an interesting case last week, and I thought I’d share what I think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods of high load on their database server, leading...
by Stephane Combaudon | Apr 5, 2013 | MySQL, Percona Software, Webinars
I didn’t have time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day,” but as promised, here are all of the questions and my answers. (A recording is available here.) Q: One of...
by Stephane Combaudon | Mar 22, 2013 | MySQL, Percona Events, Percona Software
On April 3 at 10 a.m. PST, I’ll be giving a webinar titled “5 Percona Toolkit Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration tasks. My focus will...
by David Hildebrandt | Mar 15, 2013 | MySQL
Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on...
by Bill Karwin | Feb 18, 2013 | Insight for DBAs, MySQL, Percona Events, Percona Software
Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit. This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we...
by Daniel Nichter | Feb 15, 2013 | Percona Events, Percona Software
About a month ago, we held a bug raffle for Percona Toolkit 2.1.9. The turnout was good and the resulting release is worth upgrading to, especially if you were affected by the backwards-incompatible changes to pt-heartbeat in 2.1.8. Here are the release notes for...
by Daniel Nichter | Jan 21, 2013 | Percona Software
Since we’re very busy working on Percona Toolkit 2.2 and other projects, I thought 2.1.8 (the current latest Percona Toolkit release) would be the last release in that series, but it introduced a new bug in pt-heartbeat (despite all the tool’s tests) that...
by Tom Diederich | Jan 9, 2013 | MySQL, Percona Software
Percona Toolkit 2.1.8 was released today and the new version comes with some pretty cool news: Beta support for MySQL 5.6 (which as you might know is also in beta). In addition to various bug fixes, Percona Toolkit 2.1.8 also offers beta support for Percona XtraDB...
by Martin Arrieta | Jan 3, 2013 | Insight for DBAs, MySQL, Percona Software
pt-stalk recipes: Gather forensic data about MySQL when a server problem occurs It happens to us all from time to time: a server issue arises that leaves you scratching your head. That’s when Percona Toolkit’s pt-stalk comes into play, helping you diagnose...
by Fernando Ipar | Dec 12, 2012 | MySQL, Percona Events
On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know About”. As a Consultant, I make heavy use of Percona Toolkit tools while solving customers’ problems, and I...
