EmergencyEMERGENCY? Get 24/7 Help Now!

Air traffic queries in MyISAM and Tokutek (TokuDB)

 | November 5, 2009 |  Posted In: Benchmarks, MySQL

This is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries in InfiniDB: early alpha Let me explain the reason of choosing these engines. After initial three posts I am often asked “What is baseline ? Can we compare results with standard MySQL engines […]

Read More

InnoDB: look after fragmentation

 | November 5, 2009 |  Posted In: Insight for DBAs, MySQL

One problem made me puzzled for couple hours, but it was really interesting to figure out what’s going on. So let me introduce problem at first. The table is

Table has 11864696 rows and takes Data_length: 698,351,616 bytes on disk The problem is that after restoring table from mysqldump, the query that scans data […]

Read More

Air traffic queries in InfiniDB: early alpha

 | November 2, 2009 |  Posted In: Benchmarks, MySQL

As Calpont announced availability of InfiniDB I surely couldn’t miss a chance to compare it with previously tested databases in the same environment. See my previous posts on this topic: Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB I could not run all queries against InfiniDB and I met some […]

Read More

Air traffic queries in LucidDB

 | October 26, 2009 |  Posted In: Benchmarks, MySQL

After my first post Analyzing air traffic performance with InfoBright and MonetDB where I was not able to finish task with LucidDB, John Sichi contacted me with help to setup. You can see instruction how to load data on LucidDB Wiki page You can find the description of benchmark in original post, there I will […]

Read More

XtraDB Amazon Image

 | October 25, 2009 |  Posted In: MySQL, Percona Software

For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use it. First make sure it is avaiable.

Run it. It is built for x86_64 […]

Read More

xtrabackup-0.9.5rc

 | October 24, 2009 |  Posted In: MySQL, Percona Software

Dear Community, As of today release 0.9.5rc is available. In this release there are following changes: Changelog: Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your tables are InnoDB and you DO NOT CARE about binary log position of backup XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well […]

Read More