In Part 1 of this article, I took you through some of the reasons why a column-oriented database based on MySQL can be compelling. We also examined the architecture of InfiniDB, which is an open source analytic, reporting, and read-intensive database, and how its modular design helps you scale both up and out. Now lets kick the tires of the database so you can see these things in action.
First, lets load some data into a basic database to work with. The below load and query tests were run on a small 32-bit Fedora Core 6 machine with 2GB of RAM, and 4 CPUs (2.40GHz with 512KB cache).
The article continues at http://dev.mysql.com/tech-resources/articles/mysql_datawarehouse_calpont2.html