Percona Software

XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo

Today we announce release 1.0.2-3 of our XtraDB storage engine.
Here is a list of enhancements:

Move to MySQL 5.1.31
Scalability fix — ability to use several rollback segments
Increasing the number of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results.
Scalability fix — replaced page_hash mutex to page_hash read-write lock. […]

Read more

Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas

For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing alternatives.
Innodb Hot Backup is a good working solution but […]

Read more

Pretending to fix broken group commit

The problem with broken group commit was discusses many times, bug report was reported 3.5 years ago and still not fixed in MySQL 5.0/5.1 (and most likely will not be in MySQL 5.1). Although the rough truth is this bug is very hard (if possible) to fix properly. In short words if you enable replication (log-bin) […]

Read more

Another scalability fix in XtraDB

Recent scalability fixes in InnoDB and also Google’s and your SMP fixes almost made InnoDB results acceptable in primary key lookups queries, but secondary indexes were forgotten for some time. Now having Dell PowerEdge R900 on board (16CPU cores, 16GB RAM) I have some time for experiments, and I played with queries

Shell

SELECT name […]

Read more