Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 12, 2013
Oracle Technical Experts at the Percona Live MySQL Conference and Expo
I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Oracle, will [...]
March 4, 2013
InnoDB MySQL full text search: Part 2, the queries!
This is part 2 in a 3 part series on InnoDB MySQL full-text searches. In part 1, we took a [...]
February 28, 2013
MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server
Like Ovais said in Implications of Metadata Locking Changes in MySQL 5.5, the hot topic these days is MySQL 5.6, but [...]
February 26, 2013
InnoDB Full-text Search in MySQL 5.6 (part 1)
I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to [...]
February 25, 2013
Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
There are many reasons for wanting a small MySQL database server: You’re a uni student who wants to learn the [...]
February 25, 2013
Percona Welcomes MySQL 5.6!
MySQL 5.6 was made generally available as a production-ready solution earlier this month. This release comes about 2 years after [...]
February 22, 2013
CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL
CentOS 5.8 and earlier use Perl module DBD::mysql v3.0007 which has a bug that causes Perl not to flag UTF-8 [...]
February 1, 2013
Implications of Metadata Locking Changes in MySQL 5.5
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), [...]
January 28, 2013
How Can Percona MySQL Server Development Services Help ?
At Percona we offer a number of services. One of them, Custom MySQL Server Development, is commonly the most misunderstood [...]
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 [...]