Monthly Archives - August 2009

Looking at Redis

Recently I had a chance to take a look at Redis project, which is semi-persistent in memory database with idea somethat similar to memcache but richer feature set.
Redis has simple single process event driven design, which means it does not have to deal with any locks which is performance killer for a lot […]

Read more

xtrabackup-0.9

Dear Community,
The release 0.9 of the opensource backup tool for InnoDB and XtraDB is available for download.
Changelog:

tar4ibd could not treat over 8GB file, now max 64GB
prepare-speed-hack is added

Fixed bugs:

Bug #386179: “InnoDB: Error: space id in fsp header 143088, but in the page header 0”
Bug #394374: “Can’t compile with MySQL 5.1”
Bug #394781: “xtrabackup requires write […]

Read more

Sorting a Terabyte in 197 seconds

Sorting a Terabyte in 197 seconds
I just returned from The 21st ACM Symposium on Parallelism in Algorithms and Architectures (SPAA), held in Calgary, where I gave a talk about my entry to the sorting contest. I sorted 1TB in 197s on a 400-node machine at MIT Lincoln Laboratory, a record which still stands […]

Read more

XtraDB storage engine release 1.0.3-7

Dear Community,
Today we are announcing XtraDB release 7.
This is the last release based on InnoDB plugin version 1.0.3, as you might know Innobase has released 1.0.4.
The release includes following new features:

MySQL 5.1.37 as a base release
speed hack for buf_flush_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery

Fixed bugs:

MySQL Bugs: #45357: 5.1.35 crashes with Failing assertion: index->type […]

Read more

A micro-benchmark of stored routines in MySQL

Ever wondered how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against a “roughly equivalent” subquery. The idea — and there may be shortcomings that are poisoning the results here, your comments welcome — is to see how fast the […]

Read more