Tag - Storage Engine

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

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

The MySQL optimizer, the OS cache, and sequential versus random I/O

In my post on estimating query completion time, I wrote about how I measured the performance on a join between a few tables in a typical star schema data warehousing scenario.
In short, a query that could take several days to run with one join order takes an hour with another, and the optimizer chose […]

Read more

Data Recovery Toolkit for InnoDB Version 0.1 Released

As Peter mentioned in one of previous posts, we’ve done huge work developing robust strategies of InnoDB data recovery to provide our customers effective data recovery services and one of major parts of these strategies is our toolkit for InnoDB data recovery. Today I’m proud to announce its first public release which was used […]

Read more