Q4M のベンチマーク

rev 15 で測定。mysqlslap だといい感じ。

$ ../mysql-5.1.22-rc/bin/mysqlslap -S /tmp/mysql51.sock --concurrency=10 --iterations=100 --engine=myisam,innodb,memory,queue --auto-generate-sql
Benchmark
        Running for engine myisam
        Average number of seconds to run all queries: 0.160 seconds
        Minimum number of seconds to run all queries: 0.145 seconds
        Maximum number of seconds to run all queries: 0.171 seconds
        Number of clients running queries: 10
        Average number of queries per client: 0

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 0.238 seconds
        Minimum number of seconds to run all queries: 0.174 seconds
        Maximum number of seconds to run all queries: 0.295 seconds
        Number of clients running queries: 10
        Average number of queries per client: 0

Benchmark
        Running for engine memory
        Average number of seconds to run all queries: 0.147 seconds
        Minimum number of seconds to run all queries: 0.115 seconds
        Maximum number of seconds to run all queries: 0.162 seconds
        Number of clients running queries: 10
        Average number of queries per client: 0

Benchmark
        Running for engine queue
        Average number of seconds to run all queries: 0.159 seconds
        Minimum number of seconds to run all queries: 0.092 seconds
        Maximum number of seconds to run all queries: 0.171 seconds
        Number of clients running queries: 10
        Average number of queries per client: 0