EmergencyEMERGENCY? Get 24/7 Help Now!

Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon

 | March 19, 2013 |  Posted In: Benchmarks, Cloud and NoSQL, Events and Announcements, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona Software, Percona Toolkit

Facebook is a major user of MySQL and has pushed the performance limits of the technology. Their MySQL experts have deep, hands on knowledge of the technology. I’m pleased to welcome Mark Callaghan, Software Engineer for Database Infrastructure at Facebook, back again this year to the Percona Live MySQL Conference & Expo to share his […]

Read More

Oracle Technical Experts at the Percona Live MySQL Conference and Expo

 | March 12, 2013 |  Posted In: Benchmarks, Cloud and NoSQL, Events and Announcements, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona Software, Percona Toolkit, XtraDB Cluster

I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Percona Live MySQL Conference and Expo. The conference takes place April 22-25, 2013 at the Santa Clara Convention Center and Hyatt Santa Clara. Tomas Ulin, VP, MySQL Engineering for Oracle, will present an invited keynote talk on […]

Read More

Percona Welcomes MySQL 5.6!

 | February 25, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Software, Percona Toolkit

MySQL 5.6 was made generally available as a production-ready solution earlier this month. This release comes about 2 years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text Search project was started over 6 years ago, in addition with many optimizer […]

Read More

CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL

 | February 22, 2013 |  Posted In: Insight for Developers, Percona Toolkit

CentOS 5.8 and earlier use Perl module DBD::mysql v3.0007 which has a bug that causes Perl not to flag UTF-8 data as being UTF-8.  Presuming that the MySQL table/column is using UTF-8, and the Perl MySQL connection is also using UTF-8, then a correct system returns: PV = 0x9573840 "\343\203\213 \303\250"\0 [UTF8 "\x{30cb} \x{e8}"] That’s a Devel::Peek inside a Perl scalar variable which […]

Read More

Analyzing Slow Query Table in MySQL 5.6

 | February 18, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Toolkit

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 saw the GA release of MySQL 5.6, and I wanted to check if any […]

Read More

Percona Toolkit 2.1.9 is ready

 | February 15, 2013 |  Posted In: Events and Announcements, Percona Software, Percona Toolkit

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 Percona Toolkit 2.1.9 which highlight the bugs fixed: Percona Toolkit 2.1.9 has been released. […]

Read More

Percona Toolkit 2.1.9 bug raffle

 | January 21, 2013 |  Posted In: Percona Software, Percona Toolkit

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 I’d like to fix. A single bug fix is probably underkill for a […]

Read More

Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

 | January 9, 2013 |  Posted In: MySQL, Percona Software, Percona Toolkit

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 Cluster (PXC). Version 2.1.8 continues the trend of solid […]

Read More

Percona Toolkit by example – pt-stalk

 | January 3, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona Toolkit

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 the problem by capturing diagnostic data that helps you pinpoint what’s causing the […]

Read More