DBT-3 Q1 benchmark: Check/profile reduced queries

Axel,

we're now in the same situation as we were in the previous iteration. In order to narrow down the problem, I need to get benchmark results and profiles for the simplified queries.

The queries are provided below; they should be ran on MyISAM, multiple times. Please check MariaDB 5.5 (with "the fix"), MariaDB 5.3, and MySQL 5.5.

I need profiles also. If one can observe a meaningful difference between different versions, please pick the runs that show the difference.

The queries:

explain

select

        sum(l_quantity) as sum_qty,

        sum(l_extendedprice) as sum_base_price,

        sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,

        sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,

        avg(l_quantity) as avg_qty,

        avg(l_extendedprice) as avg_price,

        avg(l_discount) as avg_disc,

        count(*) as count_order

from

        lineitem;

select

        sum(l_quantity) as sum_qty

from

        lineitem;