Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 27, 2012
Edge-case behavior of INSERT…ODKU
A few weeks back, I was working on a customer issue wherein they were observing database performance that dropped through [...]
October 19, 2012
Recovering from a bad UPDATE statement
Did you just run an UPDATE against your 10 million row users table without a WHERE clause? Did you know [...]
October 4, 2012
Tools and Techniques for Index Design Webinar Questions Followup
I presented a webinar this week to give an overview of Tools and Techniques for Index Design. Even if you [...]
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 [...]