EmergencyEMERGENCY? Get 24/7 Help Now!

Easy query metrics with MySQL Performance Schema

 | March 12, 2015 |  Posted In: MySQL, Percona Cloud Tools, Percona Server, Query Analytics

The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks: Click “Apply” and about two minutes later you’ll have query metrics from Performance Schema, collected and […]

Read More

Faster fingerprints and Go packages for MySQL

 | February 2, 2015 |  Posted In: MySQL, Percona Cloud Tools, Query Analytics

I’m happy to announce Go packages for MySQL. Particularly exciting is a new query fingerprint function which is very fast and efficient, but I’ll talk about that later. First, go-mysql is currently three simple Go packages for parsing and aggregating MySQL slow logs. If you’ve been following Percona development, you’ve no doubt heard of Percona Cloud Tools (PCT), a […]

Read More

The top 9 Percona Toolkit tools that can make your job easier: May 7 Webinar

 | May 5, 2014 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars, Percona Server, Percona Software

Tools for MySQL are a vital part of any deployment, so it’s important to use ones that are reliable and well-designed. Percona Toolkit is a collection of more than 30 command-line tools for MySQL, Percona Server, and MariaDB that can help database administrators automate a variety of database and system tasks. With so many available […]

Read More

Percona Live 2014 behind; MySQL ahead

 | April 23, 2014 |  Posted In: MySQL, Percona Live

I started using MySQL 11 years ago.  That’s not too long compared to other people in the industry, but nonetheless here’s my perspective on the state of the MySQL industry after attending Percona Live MySQL Conference & Expo 2104. In short, the attitude around MySQL has changed from “Does it work?” to “Is it fast […]

Read More

Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver

 | May 6, 2013 |  Posted In: Percona Software, Percona Toolkit

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 prints unwanted debug info on tcpdump parsing errors pt-query-digest 2.2 prints too many string values Some tools don’t […]

Read More

MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server

 | February 28, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

Like Ovais said in Implications of Metadata Locking Changes in MySQL 5.5, the hot topic these days is MySQL 5.6, but there was an important metadata locking change in MySQL 5.5.  As I began to dig into the Percona Toolkit bug he reported concerning this change apropos pt-online-schema-change, I discovered something about lock_wait_timeout that shocked me.  From the […]

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

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.