Emergency

Monthly Archives: August 2009

Give me 8 hours, and I’ll help you build a better application

I have run into a number of cases recently that all had a similar look and feel. In most of these cases, the symptoms were very complicated, but they boiled down to just a few …

Read More
 

Innodb performance gotcha w Larger queries.

Couple of days ago I was looking for a way to improve update performance for the application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw the same problem …

Read More
 

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 …

Read More
 

A few administrative updates

I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go: We’ve had reports of some lost comments.  We reported this via Twitter a …

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 …

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 …

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 …

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 …

Read More
 

XtraDB: The Top 10 enhancements

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 …

Read More
 

Innodb plugin 1.0.4 released – great job Innobase

As you might have seen Innodb Plugin 1.0.4 was released today. I am very excited to see this release which is released exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to …

Read More