Emergency

Monthly Archives: April 2009

Looking on 5.4 – IO bound benchmarks

With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested it on …

Read More
 

Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance

MySQL 5.4 comes with Innodb engine which seems to have much better performance than MySQL 5.0 – this is due to locking and IO patches from Google integrated in this release (which are similar to …

Read More
 

xtrabackup-0.6

We announce next beta version of our xtrabackup tool. Changelist includes: – set innodb_fast_shutdown=1 on xtrabackup shutdown – set innodb_write_io_threads=10 by default for fast buffer_pool flushing during recovery – build xtrabackup with –with-extra-charsets=complex Bug #357653: …

Read More
 

The Depth of a B-tree

Schlomi Noach recently wrote a useful primer on the depth of B-trees and how that plays out for point queries — in both clustered indexes, like InnoDB, and in unclustered indexes, like MyISAM. Here, I’d …

Read More
 

Detailed review of Tokutek storage engine

(Note: Review was done as part of our consulting practice, but is totally independent and fully reflects our opinion) I had a chance to take look TokuDB (the name of the Tokutek storage engine), and …

Read More
 

XtraDB storage engine release 1.0.3-5

Today we glad to announce release 1.0.3-5 of our XtraDB storage engine. Here is a list of enhancements in this release: move to MySQL 5.1.34 removed rw_lock patch, so we now use Google’s rw_locks fix …

Read More
 

The Percona Performance Presentations Are Online

The 2009 Percona Performance Conference finished up last week, and was overall a resounding success. Thanks to all of the speakers, O’Reilly, and Sun/MySQL for help making it happen! Most slides have been uploaded; look …

Read More
 

High Anxiety Whenever You’re Near

Every time I visit the Sun Santa Clara Campus, I’m reminded of Mel Brooks’s movie “High Anxiety”. The campus was known as The Great Asylum for the Insane in the 19th century, and even includes …

Read More
 

Finding the Percona Performance Conference

Having trouble finding the Percona Performance Conference? It’s upstairs near where the registration desk was (aka above the exhibition hall). Hope to see you there today & tomorrow!

Read More
 

Meet the faces of Percona this week in Santa Clara

This year we’ve assembled a team of seven Perconian representatives for the MySQL Conference & Expo/Percona Performance Conference. If you like a particular blog post we’ve written over the last year, have any other feedback, …

Read More