Q4M rev. 39 のベンチマーク

インデックスとかないし追記型のアーキテクチャだから勝って当然だけど、やっぱりうれしい。

[kazuho@KazMac:~/dev/q4m]$ ../mysql-5.1.22-rc/bin/mysqlslap -S /tmp/mysql51.sock --concurrency=50 --iterations=10 --engine=myisam,innodb,heap,queue --auto-generate-sql 
Benchmark
        Running for engine myisam
        Average number of seconds to run all queries: 1.450 seconds
        Minimum number of seconds to run all queries: 1.382 seconds
        Maximum number of seconds to run all queries: 1.521 seconds
        Number of clients running queries: 50
        Average number of queries per client: 0

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 2.466 seconds
        Minimum number of seconds to run all queries: 2.406 seconds
        Maximum number of seconds to run all queries: 2.680 seconds
        Number of clients running queries: 50
        Average number of queries per client: 0

Benchmark
        Running for engine heap
        Average number of seconds to run all queries: 1.535 seconds
        Minimum number of seconds to run all queries: 1.276 seconds
        Maximum number of seconds to run all queries: 1.603 seconds
        Number of clients running queries: 50
        Average number of queries per client: 0

Benchmark
        Running for engine queue
        Average number of seconds to run all queries: 1.041 seconds
        Minimum number of seconds to run all queries: 1.010 seconds
        Maximum number of seconds to run all queries: 1.102 seconds
        Number of clients running queries: 50
        Average number of queries per client: 0