Buy Percona ServicesBuy Now!

Implementing Parallel Replication in MySQL

 | November 8, 2010 |  Posted In: Insight for DBAs, MySQL

Based on discussions with several clients, we are strongly considering implementing a limited form of parallel replication. Single-threaded replication is one of the most severe limitations in the MySQL server. We have a brief outline of the ideas at this wiki blueprint. So far, the “binlog order” idea is the only one that is workable. […]

Read More

Webinar: MyISAM to InnoDB migration

 | November 8, 2010 |  Posted In: Events and Announcements, MySQL

Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM PST (California) time. Update: the date was originally listed as December 2nd, but that was a mistake. It’s December 1st. We know that not everyone can attend expensive conferences that require travel. […]

Read More

Baron Schwartz interviewed on WebPulp.tv

 | November 1, 2010 |  Posted In: Events and Announcements, MySQL

There’s an interview with Baron Schwartz (that’s me) on WebPulp.tv. Topics include the history of Percona’s software such as Percona Server (our version of the MySQL database server) and XtraBackup, what we do at Percona, what tools we use to do it, how to think logically about performance optimization, what ugly surprises happen when you […]

Read More

Percona Server 5.1.51-rel11.5

 | October 28, 2010 |  Posted In: MySQL, Percona Software

Percona Community, Percona Server version 5.1.51-rel11.5 is now available for download. The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.51-rel11.5 is now based on MySQL 5.1.51.  New Features Added: None  Other Changes: None Bugs Fixed  Bug […]

Read More

Impact of the sort buffer size in MySQL

 | October 25, 2010 |  Posted In: Benchmarks, MySQL

The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a per session buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way Linux allocates memory. Monty Taylor (here) have described the underlying issue in detail, but basically above […]

Read More