Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
November 22, 2010
Percona XtraBackup 1.4
Percona XtraBackup 1.4 is now available for download. Version 1.4 fixes problems related to incremental backups. If you do incremental [...]
November 17, 2010
Avoiding Fragmentation with Fractal Trees
Summary B-trees suffer from fragmentation. Fragmentation causes headaches — in query performance and space used. Solutions, like dump and reload [...]
November 16, 2010
Percona white paper: Forecasting MySQL Scalability
Ewen and I have just published Percona’s latest white paper, Forecasting MySQL Scalability with the Universal Scalability Law. This is [...]
November 16, 2010
The perils of uniform hardware and RAID auto-learn cycles
Last night a customer had an emergency in selected machines on a large cluster of quite uniform database servers. Some [...]
November 15, 2010
Shard-Query adds parallelism to queries
Preamble: On performance, workload and scalability: MySQL has always been focused on OLTP workloads. In fact, both Percona Server and [...]
November 11, 2010
Advanced index analysis with mk-index-usage
The new release of Maatkit has a useful feature in mk-index-usage to help you determine how indexes are used in [...]
November 9, 2010
Lost innodb tables, xfs and binary grep
Before I start a story about the data recovery case I worked on yesterday, here’s a quick tip – having [...]
November 8, 2010
Implementing Parallel Replication in MySQL
Based on discussions with several clients, we are strongly considering implementing a limited form of parallel replication. Single-threaded replication is [...]
November 8, 2010
Webinar: MyISAM to InnoDB migration
Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 [...]
November 8, 2010
An argument for not using mysqldump
I have a 5G mysqldump which takes 30 minutes to restore from backup. That means that when the database reaches [...]
November 5, 2010
Percona’s Commitments to MySQL Users
You probably saw the Twitter storm over Oracle’s pricing changes and InnoDB in the last few days. The fear about [...]
November 1, 2010
Baron Schwartz interviewed on WebPulp.tv
There’s an interview with Baron Schwartz (that’s me) on WebPulp.tv. Topics include the history of Percona’s software such as Percona [...]
October 28, 2010
Percona Server 5.1.51-rel11.5
Percona Community, Percona Server version 5.1.51-rel11.5 is now available for download. The main purpose of this release is to update [...]
October 27, 2010
MySQL Limitations Part 4: One Thread per Connection
This is the third in a series on what’s seriously limiting MySQL in core use cases (links: part 1, 2, [...]
October 26, 2010
Sharing an auto_increment value across multiple MySQL tables (revisited)
A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a [...]
October 25, 2010
MySQL Limitations Part 3: Subqueries
This is the third in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1, 2). This [...]
October 25, 2010
Impact of the sort buffer size in MySQL
The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a per session [...]
October 23, 2010
MySQL Limitations Part 2: The Binary Log
This is the second in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1). In the [...]
October 22, 2010
High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script
This post is the fifth of a series that started here. From the previous posts of this series, we now [...]
October 21, 2010
Percona Server with XtraDB Case Study, Behind the Scenes
We’ve published our first case study. The customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. [...]