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