Monthly Archives: January 2007

Falcon Storage Engine Design Review

Now as new MySQL Storage engine – Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL. …

Read More
Looking for someone with Chinese knowledge

We’re looking to implement CJK Support in Open Source Full Text search engine Sphinx . Initially we’re thinking to base search ob bi-gram indexing to keep it simple, especially as according to research papers it …

Read More
Getting real life query speeds with MySQL

To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query and see if there is any significant improvement. Leaving aside question of checking single …

Read More
MySQL automatic data truncation can backfire

I had a fun case today. There is set of cache tables which cache certain content in MyISAM tables and queries for these tables such as:

The “key” is CRC32 of the real key …

Read More
MySQL sources from development tree

I just want to write few tips how to get MySQL from development BitKeeper tree, as there are several tricks. First of all you need a fresh free client – bk-client2.0 http://www.bitkeeper.com/Hosted.Downloading.html . Once you …

Read More
Sphinx Developer joins our team

We’re happy to announce Andrew Aksyonoff, developer of popular OpenSource full text search software Sphinx joins our team. Andrew will now have more time to dedicate to Sphinx development so cool new features will come …

Read More
InnoDB vs MyISAM vs Falcon benchmarks – part 1

Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The …

Read More
InnoDB benchmarks

There was several changes in InnoDB to fix scalabilty problems, so I ran benchmark to check new results and also compare overall performance of InnoDB in 5.0 and 5.1 before and after fixes. Problems in …

Read More
MySQL/Innodb scalability tests after fix

This is not freshest news ever but I simply have not yet had a time to comment on it. I already wrote about interesting benchmarks Tweakers.net have done for MySQL and PostgreSQL with different CPUs. …

Read More