Buy Percona ServicesBuy Now!

Talking MySQL to Sphinx

 | April 19, 2009 |  Posted In: Insight for Developers

In the recently released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in its early preview stage but it is still fun to play with. A thing to mention – unlike MySQL Storage Engines, some of which as InfoBright […]

Read More

TokuDB Storage Engine for MySQL

 | April 17, 2009 |  Posted In: Tokutek, TokuView

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. Curt Monash posted […]

Read More

How to decrease InnoDB shutdown times

 | April 15, 2009 |  Posted In: Insight for DBAs

Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages from the buffer pool. These are pages that have been modified in memory, but not on disk. If you kill the server before it finishes this process, it will just go through the recovery phase […]

Read More

Improving TPC-H-like Queries – Q2

 | April 10, 2009 |  Posted In: Tokutek, TokuView

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 […]

Read More

XtraDB storage engine release 1.0.3-4 codename Sakura

 | April 8, 2009 |  Posted In: Percona Software

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 […]

Read More

xtrabackup-0.5, bugfixes, incremental backup introduction

 | April 7, 2009 |  Posted In: Percona Software

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:

which gives start point 1319:813219999 for further incremental backup. This point […]

Read More


 | April 6, 2009 |  Posted In: Insight for DBAs

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 Quick look into source code says

Also interesting that license […]

Read More