Dear Community, As of today Release 9 of XtraDB storage engine is available. The release includes following new features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8, but somehow it was [...]
InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000 warehouses ( which gives around 90GB of data + indexes) on my [...]
Great work Innodb Team
November 30, 2009 By 8 Comments
I thought I should praise Innodb team for all the work they have been doing recently. We see a lot of cool stuff happening, especially in the area of our interest which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long standing caching [...]
How innodb_open_files affects performance
November 18, 2009 By 4 Comments
Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not have to keep open file descriptor [...]
State of the art: Galera – synchronous replication for InnoDB
October 27, 2009 By 15 Comments
First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the bottom of the list, as this is very hard to implement properly. The idea by [...]
5.0.86-build19 Percona binaries
October 12, 2009 By 10 Comments
Dear Community, As of today the 19-th build of MySQL server with Percona patches is available. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.86 Fix from Neil Katin to userstatv2.patch fix InnoDB slowness with large queries Fixed bugs in the build: Bug #413858 in Percona patches: “Crash [...]
Speaking at Highload.ru
September 24, 2009 By 2 Comments
This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow). I’ll be presenting on a few topics: MySQL Performance Tuning (Conference Session) Quick Wins with Third Party Patches for MySQL (Conference Session) Performance Optimization for MySQL with InnoDB and XtraDB * (Full day class) This will [...]
XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
Note: This post is part 2 of 4 on building our training workshop. Last week I talked about why you don’t want to shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. Building this list was not really a scientific [...]
5.0.83-build17 Percona binaries
July 28, 2009 By 19 Comments
Dear Community, The build 17 of MySQL with Percona patches is available. New features in the release: MySQL-5.0.83 is taken as the basis The new patch innodb_use_sys_malloc.patch is added The new patch innodb_split_buf_pool_mutex.patch is added This patch splits the single global InnoDB buffer pool mutex into several mutexes for different purposes. This reduces mutex contention. [...]
Percona talks at OSCON
July 16, 2009 By Leave a Comment
The OSCON 2009 is taking place next week and we have bunch of talks we’re presenting. I am presenting Full Text Search with Sphinx, MySQL Community Patches and Extensions and Goal Driven Performance Optimization. Vadim and Ryan have a talk XTraDB OpenSource Storage Engine for MySQL. This month OSCON is taking place in Silicon Valley [...]
