Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 27, 2013
MySQL 5.6: Improvements in the Nutshell
Preparing for my talk for Percona MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of [...]
January 23, 2013
Read/Write Splitting with PHP Webinar Questions Followup
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still [...]
January 17, 2013
Webinar on Read/Write Splitting with PHP
I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think [...]
January 15, 2013
Sphinx search performance optimization: attribute-based filters
One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of [...]
January 9, 2013
Profiling MySQL Memory Usage With Valgrind Massif
There are times where you need to know exactly how much memory the mysqld server (or any other program) is [...]
December 31, 2012
MySQL Wish for 2013 – Better Memory Accounting
With Performance Schema improvements in MySQL 5.6 I think we’re in the good shape with insight on what is causing [...]
December 14, 2012
The Optimization That (Often) Isn’t: Index Merge Intersection
Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks [...]
November 23, 2012
Full Table Scan vs Full Index Scan Performance
Earlier this week, Cédric blogged about how easy we can get confused between a covering index and a full index [...]
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 [...]