Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 5, 2011
Fractal Tree Indexes – MySQL Meetup
At next month’s Boston MySQL Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use [...]
December 5, 2011
Announcing PAM authentication plugin for MySQL (early access release)
We are pleased to announce availability of an early access version of Percona’s PAM Authentication plugin for MySQL. This plugin [...]
December 2, 2011
kernel_mutex problem cont. Or triple your throughput
This is to follow up my previous post with kernel_mutex problem. First, I may have an explanation why the performance [...]
December 2, 2011
kernel_mutex problem. Or double throughput with single variable
Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are [...]
December 2, 2011
Three ways that the poor man’s profiler can hurt MySQL
Over the last few years, Domas’s technique of using GDB as a profiler has become a key tool in helping [...]
November 30, 2011
An update on Percona Live MySQL Conference & Expo 2012
We announced a while back that we were going to continue the traditional MySQL conference in Santa Clara, because O’Reilly [...]
November 29, 2011
Beware the Innodb Table Monitor
As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch [...]
November 29, 2011
Innodb vs MySQL index counts
I had a customer recently who a few strange errors in their mysqld.err log: [crayon-68d579b223f96171631062/] This customer was running Percona [...]
November 29, 2011
Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
The content of this article is outdated, look here for more up to date information. Over the last year, the [...]
November 29, 2011
Avoiding auto-increment holes on InnoDB with INSERT IGNORE
Are you using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment [...]
November 24, 2011
Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
It is no secret that bugs related to multithreading–deadlocks, data races, starvations etc–have a big impact on application’s stability and [...]
November 21, 2011
A Case for Write Optimizations in MySQL
As a storage engine developer, I am excited for MySQL 5.6. Looking at http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html, there has been plenty of work [...]
November 21, 2011
Should MySQL update the default innodb_log_file_size?
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the [...]
November 21, 2011
MySQL opening .frm even when table is in table definition cache
or… “the case of Stewart recognizing parameters to the read() system call in strace output”. Last week, a colleague asked [...]
November 20, 2011
Bug#12704861
As Mark pointed out, there isn’t a lot of detail in the release notes about what could potentially be a [...]
November 19, 2011
TokuDB v5.2 Beta Program
With the release of TokuDB v5.0 last March, we delivered a powerful and agile storage engine that broke through [...]
November 18, 2011
MySQL Life Cycle. Your Feedback is needed.
When I started with MySQL 3.22 I would start running MySQL from early beta (if not alpha) and update MySQL [...]
November 18, 2011
Eventual Consistency in MySQL
We’re told that foreign key constraints are the best way to enforce logical referential integrity (RI) in SQL, preventing rows [...]
November 17, 2011
Scaling MySQL with TokuDB Webinar – Video and Slides Now Available
Thanks to everyone who signed up and attended the webinar I gave this week with Tim Callaghan on Scaling [...]
November 17, 2011
Stewart speaking at OSDC 2011
I’ve just arrived at ANU in Canberra for the Open Source Developers Conference 2011 (OSDC). I’ve spoken at several of [...]