Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 1, 2012
Upcoming Webinar on Index Design
The proper tools and techniques for designing indexes in MySQL is a broad subject, which causes grief for many developers [...]
September 19, 2012
Logging Deadlock errors
The principal source of information for InnoDB diagnostics is the output of SHOW ENGINE INNODB STATUS but there are some [...]
September 9, 2012
How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump?
Ever ran into a situation where you saw “some important variable you really needed to know about=<optimized out>” while debugging?
September 4, 2012
When is MIN(DATE) != MIN(DATE) ?
Inspiration for this post is courtesy of a friend and former colleague of mine, Greg Youngblood, who pinged me last [...]
August 28, 2012
Sell-an-Elephant-to-your-Boss-HOWTO
Spoiler alert: If your boss does not need an elephant, he is definitely NOT going to buy one from you. [...]
August 24, 2012
Full Text Search Webinar Questions Followup
I presented a webinar this week to give an overview of several Full Text Search solutions and compare their performance. Even if [...]
August 21, 2012
Webinar for Full Text Search Throwdown
Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown. This is a no-nonsense performance comparison [...]
July 30, 2012
Percona’s “Developer Training for MySQL” is now available via Live Virtual Training
Today, Percona announces that Live Virtual Training is now an option for busy professionals. We set out to develop a [...]
July 26, 2012
SQL Injection Questions Followup
I presented a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other [...]
July 18, 2012
News Flash: SQL Injection Still a Problem
The threat of SQL injection has appeared prominently in the news recently: An SQL injection vulnerability resulted in an urgent [...]
June 30, 2012
Find unused indexes
I wrote one week ago about how to find duplicate indexes. This time we’ll learn how to find unused indexes [...]
June 20, 2012
Find and remove duplicate indexes
Having duplicate keys in our schemas can hurt the performance of our database: They make the optimizer phase slower because [...]
May 30, 2012
Data Compression in InnoDB for Text and Blob Fields
Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working [...]
April 2, 2012
Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz [...]
March 22, 2012
BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities [...]
February 20, 2012
How to convert MySQL’s SHOW PROFILES into a real profile
SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. [...]
February 15, 2012
Optimize Your SQL With Percona’s Online Query Advisor!
Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the [...]
January 24, 2012
linux.conf.au 2012 roundup
I spent last week at linux.conf.au in Ballarat, Victoria (that’s the Victoria in Australia, not wherever else there may be [...]
December 27, 2011
MySQL Training in Frankfurt, Germany
We will be holding our highly acclaimed MySQL workshops in Frankfurt, Germany the week of February 13th. Early registration is [...]
December 13, 2011
MySQL Training in Washington, DC
Many of you have seen the announcement for our Percona Live in Washington, DC in January! But did you know [...]