EmergencyEMERGENCY? Get 24/7 Help 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

MySQL and IBM

 | 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 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-33.html. Quick look into source code says

Also interesting that license […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.