May 26, 2012

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

… in numbers. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #10 and ran it on TPC-H dataset (InnoDB tables…_name, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now let’s see how effective is…. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Ok so now…

Post: TPC-H Run on MySQL 5.1 and 6.0

… on TPC-H queries for the client and they kindly allowed us to publish results which are very interesting. This is obviously not audited TPC-H… kill extremely long running queries to get results for others this means we can’t really get a valid TPC-H result from MySQL,though… complete all queries within an hour. We can also see MySQL 6.0 improving query 20 speed dramatically, the rest of the queries is…