Monthly Archives - April 2009

TokuDB Storage Engine for MySQL

Tokutek officially announced the TokuDB for MySQL v2.0 Storage Engine, v2.0 on April 16th, 2009. TokuDB uses Fractal Tree (TM) technology to boost MySQL performance for users challenged with interactive querying in high volume, always-on applications. As a pure SW storage engine, TokuDB provides drop-in compatibility for existing MySQL code and applications. […]

Read more

Improving TPC-H-like Queries – Q2

Posted by Bradley C. Kuszmaul and David Wells

Executive Summary: A MySQL straight join can speed up a query that is very similar to TPC-H Q2 by a factor of 159 on MySQL.
Recently, we began looking at TPC-H performance on MySQL. Our early
tests yielded unexpectedly poor performance for MyISAM, InnoDB and the
Tokutek storage engine. […]

Read more

XtraDB storage engine release 1.0.3-4 codename Sakura

Today we glad to announce release 1.0.3-4 of our XtraDB storage engine.
Here is a list of enhancements in this release:

Move to MySQL 5.1.33
Move to InnoDB plugin 1.0.3

more reliable replication, innodb_overwrite_relay_log_info patch now included in the release

fix assertions for UNIV_DEBUG

new fix for rw_lock patch

Percona XtraDB 1.0.3-4 (Sakura) available in source and several binary packages.
XtraDB […]

Read more

xtrabackup-0.5, bugfixes, incremental backup introduction

I am happy to announce next build of our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup.
Incremental backup works in next way. When you do regular backup, at the end of procedure you can see output:

Shell

The latest check point (for incremental): ‘1319:813219999’
>> log scanned up to (1319 813701532)
Transaction […]

Read more

MySQL and IBM

No, this is not about Sun and IBM 🙂 This is about MySQL. If you download latest 5.1.33 source code you may find there storage/ibmdb2i directory, which obviously is IBM DB2 related. Interesting that there is no mentioning of new engine in Announcement http://dev.mysql.com/doc/refman/5.1/en/news-5-1-33.html.
Quick look into source code says

Shell

MYSQL_STORAGE_ENGINE([ibmdb2i], [], [IBM DB2 for […]

Read more