Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
October 6, 2011
When Do InnoDB Table Statistics Update?
InnoDB table statistics are used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. [...]
September 14, 2011
SELECT UNION Results INTO OUTFILE
Here’s a quick tip I know some of us has overlooked at some point. When doing SELECT … UNION SELECT, [...]
August 30, 2011
Explaining Indexes with a Library Metaphor
My favorite metaphor for explaining indexes is comparing them to index cards in an old library. In an old library, [...]
August 8, 2011
Preprocessing Data
There are many ways of improving response times for users. There are some people that spend a lot of time, [...]
April 25, 2011
MySQL at Facebook, present and future
Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing keynote at Percona Live [...]
April 20, 2011
Drop table performance
There have been recent discussions about DROP TABLE performance in InnoDB. (You can refer to Peter’s post https://www.percona.com/blog/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these [...]
April 7, 2011
Innodb row size limitation
I recently worked on a customer case where at seemingly random times, inserts would fail with Innodb error 139. This [...]
April 4, 2011
MySQL caching methods and tips
“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires [...]
April 4, 2011
InnoDB Flushing: Theory and Solutions
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some [...]